MS 2010 Access Forms and Lookups
Posted on 2014-12-10
I am trying to create an Access Form to replace the Excel Workbook we currently use.
The Excel Workbook had a series of VLookup functions and drop downs to keep the entries accurate and consistent.
I am looking for help on how to do this in Access 2010.
Example 1) In the Form, an employee will select the type of new business he/she wrote and the proper bonus amount will then be displayed automatically. The bonus amount is dependent on the type of new business.
Example 2) An employee will select the company and then the line of the new business, enter the premium amount, and then the correct commission rate will be selected to display the earned revenue. The rate is dependent on the line. The line is dependent on the company.
Thank you for your help.