Query with Input Box

[Rica]

I have a query, which works fine with the criteria in the
date field written manually. But since I don't want the
client to go to the code and write down the date, rather
just have an Input Box asking for the date and have the
query running. Can anyone suggest how it can be done??
Since I do this with the report but couldn't figure it out
with the query. I would appreciate any help in this
matter. Thanks in advance.

 

[Fredg]

Rica,
Instead of having the criteria written as something like:

9/1/2003

Write, on the DateField criteria line:

[Enter the Date]

Or, if you wish to return records between certain dates:
Between [Enter From Date] AND [Enter To Date]

The user will be prompted for the dates.