Automatically Fill Fields

[mespo55]

I'm kinda new at ACCESS, and I've accepted an assignment that is giving me some trouble. For beginners, I could use some help as follows:
I am constructing a data entry form that is keyed on PID (Personal ID). I would like to be able to have certain fields in my form (Name, Title, Department, etc.) fill in automatically from information already stored in a different table, also containing the PID (which I can set as key). I would like this action to occur either when the PID field has reached 3 characters or when the PID field has LostFocus.

Thanks for any help in advance.
MAE:

 

[pablofonto]

You could try creating your form based on the table you have the information on and in your table use a combo box to look up a record from the table based on what you select in your combo box. You can specify the combo box to be your personal ID, if you use the wizard the option you need to choose is the third one down.

 

[mespo55]

Hi pablofonto:
Thanks for your trying to help. I guess I'm too new at this, but I don't fully understand your response. Let me give you some more details about what I'm trying to do.
1. I'm constructing a Main Form that is used to fill a table call Main Table. Multiple users will be filling out the form and ultimately submitting (emailing) to a central person who is managing and acting on the data.
2. The same multiple users will be filling out the forms many times, so a second table, called Employee Data, exists containing the users PID, Last Name, First Name, etc.
3. When the user opens the Main Form, I want him select his PID from a combobox or dropdown list, click on it and have Access automatically fill in the other fields (Names, etc) and have all this data be entered into (update) the Main Table when the SUBMIT button is clicked.
Upon click, by the way, an email (in Lotus Notes) will be initiated, but that's a question for another time. Please help me solve the first one now.

Thanks again in advance,
Mespo55