find record

[sweetpea58]

I forgot to mention that my form is based upon a table, i have created other tables and forms based on this one therefore I don't want to change a lot of stuff. I tried the forum but nothing helped.



I have a form with about 10 fields, i added a find button to search for a record, using three fields, when this button is click i want it to display all the info pertaining to the search criteria, (this will be displayed on the same form populating in the form which contains other feilds) or a error saying record not found.

Thank You

 

[trucktime]

find

Search the Forum, there are several excellent examples for searching records.

 

[mohammadagul]

base you form on a query
in the query cirteria for each file yiou would like to search type the following

Like @*@ &[Forms]![YourFormName]![YourSearchFieldName]& @*@

in the form on the after update of search text box

me.form.requeru