This document is for passing parameters from Access to an outside app. I just want to simply take three values (one text value from a combo box, two DATE values from a Calendar control) associated with the Access form controls and have a Query in Access CALL these three values for Criteria filters. There's a button on the form to run the Query. So, something like this in the Criteria of the Query:
The DATES from the Calendar control are trickier because of the syntax of the criteria. I thought this would work (but didn't):
Between [Forms!]![Switchboard]![StartCalendar] AND [Forms!]![Switchboard]![EndCalendar]
Guess I'm not sure whether I should assign a variable for the form control values (selected Combo box value, Calendar Start Date, and Calendar End Date), or can I simply enter criteria in the query to call the object values without specifying variable in the form with VBA. I've tried both without success - probably just bad syntax.