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

Chapter 21. Taking Charge of Forms > Using a Parameterized Query As a Form’s Re...

Using a Parameterized Query As a Form’s Record Source

A query that prompts the user to enter information is called a parameter query. The information that is entered in turn become criteria in the query. You enter the prompt enclosed in brackets (as if it were a field) in whatever field or fields you want to add criteria. After the query is ready, you can attach it to a form as a record source. Let’s say that your coworker wants to add criteria to a query so that the user can open the form displaying the claims for whatever state was selected. You then could add another parameter to make the query select date ranges. After selecting the parameters, the user can browse the records of selected data. All this can be done with very little effort.

Follow these steps to create the query, and then attach the query to a form. Finally, browse the form to verify the data.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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