Create form for searching

[Guest]

I downloaded the recipes template database from Microsoft and I am wanting to
add a form in that allows users to search the records for a particular
ingredient and then display those recipes that contain that specific
ingredient. I can do this using a query no problem, but I don't know how to
get it done using a form.

 

[kingston via AccessMonster.com]

Create a form based on the query, and use input from the form for the query
parameter.
Since you have a query, use the form wizard to create a form.
Open the form in design mode and add a textbox or other input control to the
header.
Open the query in design mode and change the criteria to point to the newly
added form control:
e.g. [Forms]![FormName]![Textbox0]
Use the input control's AfterUpdate event to requery the form's data:
Me.Requery