Search a Field using a Textbox?

wayniac

Hello, my name is Wayne and I would like to type in a textbox so that it may search the a table in that specific field for results. But I wish for it to display all of the fields in that query.

Here is an example:

(input just this one field)
First Name: __________

(output information relating from that one field)
First Name: __________
Last Name: __________
SIN: __________
DOB: __________

Any help would be much appreciated.

BradHodge

Take a look at this posting and see if one of these would do what you want it to.

how to Retreive previously entered data??

Good Luck,

Brad.

wayniac

Yes Brad, that seems to be the way I am trying to go, although I still need it to reload everything in that record rather then an individual field.

Here is an example:

(textbox input) This is what was typed
field 1

(output) This is the results of what was typed
field 1----------field 2----------field 3----------field 4

All of the output fields are related to field 1 entry which was typed.

BradHodge

If your other text fields are on the same form that your search text box is on, you can use that "FindAsUType" module that Allen Browne wrote. It allows you to select the field that you want to search, lets you type in your search string, and then finds the table (or query) record you are looking for, and fills the other text boxes on your form. You are essentially filtering your recordset for that form.

If you don't need something that fancy, you could also change that initial textbox to a combobox and have it be your filter device. Just use the wizard to create the combo box and it will guide you through finding a record on your form that is based on your combo box selection.

Brad.