Calendar Control Help Please
Hi, Im very new to access but I think I have the basic idea of it.
I have a form which I added Calendar Control 10.0, when I double click a date on the calendar I want it to invoke a query based on only the date I picked. (My table is an event planner, so when I double click a date, I want to see all the events on that day only). Right now, Ive got this: (which is showing me every record in my database)
Private Sub Calendar3_DblClick()
DoCmd.OpenQuery "BOOKINGS Query"
End Sub
How do I get it to show me only the events I have on that date? I guess I have to bind the calendar somehow to sort on my "BOOKING-DATE" field, but I dont know how or where to do it. Thanks in advance.
Hi, Im very new to access but I think I have the basic idea of it.
I have a form which I added Calendar Control 10.0, when I double click a date on the calendar I want it to invoke a query based on only the date I picked. (My table is an event planner, so when I double click a date, I want to see all the events on that day only). Right now, Ive got this: (which is showing me every record in my database)
Private Sub Calendar3_DblClick()
DoCmd.OpenQuery "BOOKINGS Query"
End Sub
How do I get it to show me only the events I have on that date? I guess I have to bind the calendar somehow to sort on my "BOOKING-DATE" field, but I dont know how or where to do it. Thanks in advance.