Using Calendar to set focus on a query by the date selected

[Brott]

I have seen queries that have used a calendar to base it's query on. That didn't sound that good but I know you will know what I am talking about. Now what I am asking maybe out of this forums help. I am asking to have someone walk me through this entire process. Once I see it done where I can follow how it is done I will be good to go. If anyone is up to that or if that is above what this forum is about then just let me know.
I thank you in advance for the assistance.

 

[TheToeOfPooh]

Re: Using Calendar to set focus on a query by the date selec

How about
Using a criteria in a query which prompts the user for a relevant date?
I have based a test on the Event management dtatabse which comes with access 2000.

I created a query based on the Events table
Field = Start Date
Table = Events
Sort = I left this blank you could do it by ascending if required?
Show = I ticked this check box to display the results
Criteria = I typed the following Like[]

Then when you run the Query an InputBox pops-up prompting for a date.

HTH
Bernard