How do I pass the date clicked on a Calendar to a parameter query.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a simple application and want to select a date from a calendar and run
a parameter query. how do i do that? Thanks
 
Your calendar named MyCalendar is on a form we will call PFrmMyCalendar. Add
a textbox named MyDate to the form and set its visible property to false.
Put the following code in the calendar's AfterUpdate event:
Me!MyDate = Me!MyCalendar.Value
Put the following expression in the criteria of the date field in your
query:
Forms!PFrmMyCalendar!MyDate
You now need to put this all together in however you have your system set up
so that you open the calendar form, select the date then run the query.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Invalid bracketing of parameter name 1
Creating an update query that uses multiple parameters 2
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Date parameters in a query 3
Calendar & Access 2002 3
Modify Parameter Query 1
Calendar on report 1
Query Parameter using multiple options 0

Back
Top