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

Chapter 13. Let's Get More Intimate with... > Switching a Form's Record Source

Switching a Form's Record Source

Many developers don't realize how easy it is to switch a form's record source at runtime. This is a great way to use the same form to display data from more than one table or query containing the same fields. It's also a great way to limit the data that's displayed in a form at a particular moment. Using the technique of altering a form's record source at runtime, you can dramatically improve performance, especially for a client/server application. Here's an example found in the ShowSales form of the Solutions database. (See Figure 13.20 and Listing 13.1.)

Figure 13.20. Changing the record source of a form at runtime.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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