Query Parameters passed from Form
Posted on 2003-10-29
In my database (mdb, not adp) I have a parameter query similar to the following:
PARAMETERS PeriodBegin DateTime, PeriodEnd DateTime;
SELECT EmployeeName, TimeEntered
WHERE EntryDate Between [PeriodBegin] and [PeriodEnd]
This query supplies data to a chart in Form A. I would like to create a Form B to supply the parameters to the query. I do not want to specify the form name in the query because I would like the query to be reused with different forms.
How can I pass the parameters to the query from any form?