creating search form

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. Set
your forms recordsource to the table your data is in. Add a combobox
and select the 3rd choice in the wizard 'Find a record in a
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 place
them in the form. Whenever you select an ID# all those fields will
show the information for that record. If your data is spread out
through more than one table, create a query for all the necessary
tables and base your form off that query.

Let me know if you need any more help.

Shiner


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/