March 19th, 2009, 01:13 PM
Join Date: Mar 2009
Time spent in forums: 3 m 23 sec
Reputation Power: 0
A follow up:
I did this, several times in fact, and get it to work. But when I close my database and reopen it, it doesn't work. I don't get why it forgets what to do, lol. I'm running Access 2007.
Originally Posted by lwells
Place a text box on your form for the user to enter the age in. Then in your query design in the criteria row below the age field place this syntax:
Use your form name and the text box name that you use on your form. This will open the query filtered by what the user typed in the textbox.
Place two text boxes on your form. Give one the name of StartDate and the other the name of EndDate. Then in your query design view in the criteria under the date field place this syntax:
Between [Forms]![FormName]!BeginningDate] And [Forms]![FormName]![EndingDate]
Just use your form name.