make form from a query

[scottappleford]

how do i make a form from a query using parameters. when the form opens i would like it to ask criteria to find the record.

thanks

 

[charityg]

Create your parameter query, for example

Select * from tblYourTable where YourDate Between [enter start date] and [enter end date]

Save the query, then set the recordsource property for the form to the parameter query you just made.