Having a problem prepopulating fields

[lucpian]

Hi All,


I am having a problem. I am working with an access form that everything works okay, except that I would like if the client enters the Employee_ID, and hits the enter key, it should automatically prepopulate the other associated fields without requiring one to scroll through the over 9000 records. Please, I need your help.

Thanks

Lucpian

[OBP]

lucpian, I hope that you are not storing this "prepopulated data" in another table as this is not the correct way to do it?
If you just wish to "Display" the Employee's data on a form that is fine,
You can do this using an Employee Combo box instead of your an employee field and select the Employee from a list. The Combo box "jumps" to the Names as you type in the letters so it is a very quick way to select an Employee even when there are 9000 of them. It is also much safer than typing in to a field and making typing errors which you won't know until it doesn't find the requiured record.
In the Combo box you can have all of the other employee fields that you want and use very simple VBA to then display them.