Run Query from form

[mshirwan]

Does anyone know how to run a query from form and set the query parameters to fields in the form.

This is what I have a query that have a date between start date, End date, I want to be able to run it from a form and set the query paramiters from the start date field that I have on the form?

any ideas?

 

[Mile-O]

DoCmd.OpenQuery "MyQuery"

The parameters should be included within the Query already like so:

[Forms]![MyForm]![MyControl]

 

[mshirwan]

many thanks

that worked fine, thank you

Dont know why i havent thought of that, as i have used the tecknick for filtering data into a combobox on a form.