running query with form data

[stevie1969]

I have a form that has a start date field and an end date field and a client ID field. When I click a button to run a query I want the query to take the start date and end date and filter the query on those dates and also only supply data for the client ID

at the moment when I run the query i manually type the start date and end date and then scroll down the client ID to the one I want.

any ideas how to do this from the form

many thanks

 

[FoFa]

In your query criteria, you need to reference you form fields is all. FORMS!YourFormName!YourFieldName

 

[stevie1969]

got it now thanks