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

The easiest way to do this is to modify the recordsoure for the form to be a query that joins the employee table to whatever other table you are using. That way you can use bound fields to show the employee information. When you use this method, you should change the properties of the fields that come from the employee table to "enabled = no", "locked = yes", "tab stop =no" to prevent accidental updates.

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.