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.

[wayniac]

Thank you very much. This module works excellent. Its exactly what I wanted to do.

[wayniac]

One last question, is there anyway of removing certain fields from the table? I still want them in there, just not visible to for lookup.

[wayniac]

Never mind, got it working. Thanks again :)