Custom Search!

[esu4edp]

I have a form with one text box on it. I would like the user to enter a social. If there are any matching socials from tbl suspects, I want it to display the information from that table, if not I just want it to display "No Records Found"

I tried using the after update event assigned to a macro the opens a form with all the records from my tbl suspects and applying a filter from a query of that table. But it displayes all of the records.

Where have I gone wrong!

 

[raskew]

Check the help file for FindFirst method. The technique is discussed in depth, with several examples.

 

[FEDSEC]

Create a query from the table that you want to use adding the fields that you want in the report. Int the column of the field that you want to find matching records, put something like [Socials] in the criteria line. When you run the query this should give you a message box asking
"Socials" and should all records that match.

Base your report on this query.