Applying a date range from a form to a query...

[smpayne]

I have a simple form where a user selects a query from a drop down list. I need to have the query apply a date range that has also been selected in the form.

Would I call to the date form fields from the query as a variable somehow?? If so, could someone show me the syntax? I am extremely new to access.

Help!

 

[Jibbadiah]

You could put the following in the criteria section of a subsequent query... and then use this query as the basis for a form, report, etc.

Between [forms]![FormName]![FirstDateParam] And [forms]![FormName]![SecondDateParam]

 

[smpayne]

Thank you!

Excellent! Much appreciated.