Populate form with data

[moepower]

hi all, i'm an access newbie so execuse the simple question.

i have a form with the following fields:

employee_id
first_name
last_name
department
specialty

if the employee goes in and enter their employee_id, i want the rest of the fields to be populated on the same form when they tab out of the employee_id field. how can this be done?

thanks,

 

[DreamerZ]

The easiest way is by using the Combo Box wizard to create a new combo box for the employee id. Using the Wizard allows you to set the combo box as a record find feature.

The first selection in the wizard should be "Find a record..." On the available fields, add the employee id.

Click Finish and the code will be created.

With a combo box, users can either type their id in or select it from the drop-down. Doing so will populate the form with the record associtated with the id selected.

Hope that helps.


DreamerZ
simplesolutions@prodigy.net
[ignore]

http://www.geocities.com/simplesolutions@prodigy.net

[/ignore]

 

[moepower]

Thanks DreamerZ. I'll give it a try.