1. When using a form for entering data, I want to enter in a employee ID, then in the two fields below, I would like the last name and first name to automatically filter in from the tables after entering in the employee ID.
2. When chosing a Class ID from a drop-down (combo box), I want the other information (class title, location, date, time) that is linked to the class ID to automatically filter into the empty fields below.
The easy/easy way? Use a command button. Create it using the Command Button Wizard. Under Categories, choose Record Navigation (the default); under Actions, choose Find Record. Complete making the wizard entries, and at the end, Access will create the code for you.
Depending on your form's Record Source property, and whether you're using bound or unbound text boxes, you may need to manually (with code, of course) populate the other text boxes.