Using a form to search

[Jordan Shoderu]

I would like to be able to enter a number that is in a record and i bring up
all the related infomation.
Thus i will have a blank form with all the text boxes on it and then when i
enter the record entry it will automatically search and bring up the
neseccary related records
is there anyway that i can do this

Jordan

 

[Albert D. Kallal]

I would like to be able to enter a number that is in a record and i bring up
all the related infomation.

You don't mention what/ or which number you are talking about. However, use
the wizard to build a combo box. (one option is to build a search combo, and
whatever you type into the combo box, the record will be displayed).

You can also use query by form, and turn an existing form into a search
form, and thus most fields are searchable that way
(while viewing a form you can go records->Filter->Filter by form

Also, as a last resort, you can put your cursor into a field and whack
ctrl-f.