Populate field boxes

[Darth21]

In Access, I want to autopopulate the first name last name and department when I scan the Employee ID. Does anyone know how to do that?



Thanks, Brian

[June7]

You want to autopopulate unbound textboxes just to display the related info?

One way is to scan into a multi-column combobox. The columns would have the ID, names, and deptartment info. Then the textboxes can have expression that references the appropriate column of combobox.