creating search form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top