I created a new form with a calendar. I tried to click a day and it is bringing up all the days again. This is the expression I used in my date field: (="#" & Forms![name of form with calendar]![name of calendar control] & "#" ). Every time I try to run the query it will basically say that the expression that I entered is to complexed. I guess my question is that how do I make a connection between the day I click into the calendar and the command button that I want to do. Please Help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Calendar Control!!!!!!
- Thread starter cell0042
- Start date
RobertT687
Programmer
Change the field criteria in the query to [Forms]![name of form with calendar]![name of calendar control]
Data from the calendar control is already recognized as a date (no #'s needed).
Data from the calendar control is already recognized as a date (no #'s needed).
- Status
Similar threads
- Locked
- Question
- Locked
- Question