I have a form called Detail Inspection Plan. The record source table is called Detail Inspection Plan (DIP). On the form and in the table I have the following fields, Lot Quantity, AQL, and Sample Qty. The AQL field is a combo box with the following selections: 100, .65, and 2.5. There's a table called AQLT that was created to hold the AQL Sampling Plan matrix. The table has the following fields, ID, Lot quantity Start, Lot Quantity End, AQL, and Sample Qty. The lot quantity range (Start & End) along with the applicable AQL, determins the sample qty. I want the user using the Detail Inspection form to enter in the quantity of their lot (how many pieces they have) into the Lot Quantity field and select the AQL (sample plan) they're using from the AQL combo box. In return, after they've entered in the quantity into the lot quantity field and selected their AQL; I want the Sample Qty field to automatically return a Sample Qty from the Sample Quantity field in the AQLT table. How do I achieve this using VBA in Access?  Thank you.