Form Filtering

[Jamie Dickerson]

I have a form ToolingIn based on a query. Upon opening the form the user is
prompted to enter a date. This filters the records for the date entered. In
order to filter for a new date the user must close the form and reopen. I am
sure there is a better way to do this. I played with the command button
wizard a bit but with no success. I first tried the run query command which
does prompt the user for a new date but then opens the query. I would like
it to open the form. I also tried using the openform command but that does
nothing. Any help would be appreciated.


Thanks In Advance.

 

[Marshall Barton]

I have a form ToolingIn based on a query. Upon opening the form the user is
prompted to enter a date. This filters the records for the date entered. In
order to filter for a new date the user must close the form and reopen. I am
sure there is a better way to do this. I played with the command button
wizard a bit but with no success. I first tried the run query command which
does prompt the user for a new date but then opens the query. I would like
it to open the form. I also tried using the openform command but that does
nothing.

Add an unbound text box to the form's Header section for
users to enter the date. Then change the query's critreia
from your prompt string to:
Forms![name of the form].[name of the text box]