help with fields in a form

I started with excel and have a list of user accounts and properties. Then i imported into access when i figured out how and created a form to give a front end on adding new users.

My question is how can i use one of the fields to bring up a users information for instance if i have fields for users last name, first name, address, phone number, I would like to use the last name field to type in a users name and press enter and have that users information appear in the other fields. Currently if i type in any of the fields it is over writing that field for that particular user.

Thanks for any ideas.

Hi,

If you are using a bound form (in design mode of form all the textbox will show the fieldname and the form recordsource will display tablename) created by wizard just put an command button with wizard for record find. Then put the cursor on any field and click the find button. you will be prompted for field value. Once you enter the value in the prompted text box the related record will be displayed. There are better methods with unbound form which needs little more programming.