create a form

[vicgirl]

Hi,
Does anyone know how to create a form which let the user input some search criteria and the results will be listed in the same form by using the Docmd.RunSQl() instead of requery()? How is it done to have multiple records display?
The form is similar to the following:
Input Name: Date From: To:

Search Button

Results:
ID Date Name


Thanks in advance!

 

[doran_doran]

Try Dev Ashish Sample database...

http://www.mvps.org/access/forms/frm0045.htm

It worked for me. Excellent source database for your purpose.

Good Luck