linking fields

[yoda]

Is it possible to have data atomatically enter into a field when an id nunber is entered into another field and how is this done.I would to make it so when i enter an employee# his name and senorioty date will enter in there own fields in the form
thanks yoda

 

[jaydlewis]

also see reply to Wally's "Populate fields of form after entering data in one field" about a more direct/secure approach: reference additonal columns of the recordsource of the initial control (ie the combo box for selecting ID); post back for more/specific assistance.