creating search form

T

Tony

I need to create a form that will search records I have in a table. I want to have a text box where the user can enter the record id #. Then click a search button and the record and all of it's information is displayed in the bound text boxes.
 
S

Shiner452

There are several ways to do this...the easiest is probably this. Se
your forms recordsource to the table your data is in. Add a combobo
and select the 3rd choice in the wizard 'Find a record in
table/query'. Select the ID# field as the data you wish to display.
Next, select all the fields whose data you wish to display and plac
them in the form. Whenever you select an ID# all those fields wil
show the information for that record. If your data is spread ou
through more than one table, create a query for all the necessar
tables and base your form off that query.

Let me know if you need any more help.

Shine
 
Top