Want more Access tips and tricks? Automatically sign up for our free Microsoft Office Suite newsletter, delivered each Wednesday!
You can reduce typing time by basing your Access forms on AutoLookup queries. For example, let's say you need to develop an Order form that includes fields from both the Customers table and Orders table. Rather than creating the form from these tables, you can base the form on an AutoLookup query that will automatically fill in the customer information once the CustomerID is entered.
Follow these steps to create an AutoLookup query:
- Create a new query with the Customers and Orders tables.
- Drag the CustomerID field (that joins both tables) from the Orders table to the query design grid.
- From the Customers table, drag the fields you want to be filled in by the query, such as Name and Billing Address fields.
- Add additional fields needed from the Orders table.
- After running and testing the query, create an Order-entry form based on this query.
When the user enters the CustomerID to enter a new order, Access automatically fills in the data from the Customers table.