Creating a Search

[JennJenn]

I have a form that I would like to allow the user to search data from the form's table by Name and Date. How would I get started with this? Would I have to create another table?

Thanks David. You're THE BEST!!

[This message has been edited by JennJenn (edited 05-22-2002).]

 

[David R]

Nope, you just use the (unbound) fields on your new form to filter the records on the table when you open it.

Example: In the Click event for a "Open Form" event on your search form, you put something similar to this:
DoCmd.OpenForm "Regular Form",,"[NameFieldInForm'sRecordSource] = '" & Me.NameSearchField & "' AND [DateField] >= #" & Me.DateSearchField &"#"

Keep in mind you are filtering the recordsource, not the form, so use the field names, not the control names on "Regular Form".

Good luck,
David R