If you find that users need the information on one form to enter information on another, you can save them a considerable amount of time if they can open both forms at once using Access. For example, your customer service department takes appointments over the phone. To do so, they open the Appointment Calendar form, which includes a Calendar object and the Customer's name and ID number. To identify the Customer, the representative asks for certain information, which they can verify on the Customer Names and Addresses form.
To open two forms to display concurrently, follow these steps:
- Open the Clients Database.
- In the Clients Database Window, click Macros under Objects.
- Click the New button.
- Click in the first Action cell and scroll to and select Open form.
- Under Action Arguments, click in the Form Name box and select Customer Names And Addresses.
- Under the Where Condition box, enter the following:
[Customer ID] = Forms![Appointment Calendar]![Customer ID].
- Click the Save button, name the form OpenCust, and click OK.
- Click Close.
- Click Forms under Objects in the Database Window.
- Click the Appointment Calendar form and click the Design button.
- Double-click the form's Property button, and click the Event tab.
- Click the On Current property box and select OpenCust.
- Save and close the form.
When you open the Appointment Calendar form, the Customer Names and Addresses form will open beside it, and the name in the Appointment Calendar will automatically match the one in the second form as you scroll through the records. Looking at the Customer Names and Addresses form, the service representative can verify the customer information before making the appointment.
Miss a tip?
Check out the Microsoft Access archive, and catch up on our most recent Access tips.
Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.