• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Forms > Form Filters

Form Filters

You can use the filter variants Filter By Selection and Filter By Form that you are familiar with from working with Access mdb forms for adp forms as well. Note that both filter variants work with local data, which means that prior to applying filters you must first import all data to the client. This can cause bottlenecks if there are large tables on the server, because all the data must first be transferred to the client. Also, the filter always edits only those records that were actually imported to the client, and the form property Max Records normally limits the number of records that can be imported (the default setting is 10,000).

Server Filters

Microsoft has introduced the properties Server Filter By Form and Server Filter that make it possible to filter all of the data while it is still on the server so that only the filtered data is transmitted to the client.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint