You can greatly enhance a form by having Access supply information based on the user's selection. Here's an example that will fill in an employee's first name and phone number when the user ...

Control how your data records will display when a user opens a form in your Access application -- Single Form, Continuous Forms, Datasheet, PivotTable, and more -- by setting a default. Here's how.