Newbie

[Guest]

I am a total N00b at access and coding within. I would like to learn more,
Especially how i can when i press the command button search that it will look
in table "users" and find the user id which was typed in textbox1. so that in
principle the id is shown. the name in textbox2, the contact details in
textbox3 etc.

 

[John W. Vinson]

I am a total N00b at access and coding within. I would like to learn more,
Especially how i can when i press the command button search that it will look
in table "users" and find the user id which was typed in textbox1. so that in
principle the id is shown. the name in textbox2, the contact details in
textbox3 etc.

Rather than a textbox, consider using a Combo Box. Unless users are
familiar with and comfortable with entering UserID's, I'd suggest
concealing them from view altogether; a Combo Box can look up an ID
while displaying a human-friendly name.

The Form toolbox combo box tool, with the "magic wand" icon selected,
will give you the option to create a combo box to "find a record on
this form".

John W. Vinson [MVP]