find records using form

[SecretCharacter]

Hi all,
Need your help on the following:
I have a form with four fields from the same table. I use one of the field
as a means of searching for the right record. So how do I code it such that
when i key in the search field and search for the record, the form will
search and present the rest of the fields of the record on the form.

The table name is tblUser
The fields are:
DirectoryID ---->search field
Full name
Email
Location

The form name is frmUser
It has:
txtID ----->for typing DirectoryID
txtName ----->for Displaying Full Name
txtEmail -----> " " Email
txtLocation ----->" " Location
cmdFind ----->for initiating the search

The action is to type in the directory id then click on the cmdFind and will
search for the right record and display the rest of the fields of the record
on their respective txtBox in the forms.
Lastly, when we find the record, how do we set the record with a mark so
that when i edit the information of that record, it will reflect
accordingly? Thanks a zillion.......

This newsgroup absolutely rocks!!!!

Merry Christmas to all
----SecretCharacter

 

[Allen Browne]

Provide an *unbound* text box on the form, where the user can enter the ID
to find. Use its AfterUpdate event procedure to find that record in the
form.

There is an example of the code in this link:
http://members.iinet.net.au/~allenbrowne/ser-03.html
The example is for a combo box, but a text box works just as well.