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 ...

Click the "Quick Parts" button and select the "Text Form Field" option, which will insert the field and open a separate dialogue window. Click the "Formula" option in the "Field names" section.