Help creating a variable/calculation field in a form in Access 2010.
Posted on 2011-03-19
This seems like it would be pretty easy however I don't have much experience in forms. I'm trying to create a form to display our prices depending on what fields are chosen. I have 3 tables, Quantity, Stock, and Flavor. Each table has a key field, a description field, then a number field. What I'd like to do is display the description field as a combo box for all three tables, then calculate the number fields for those tables off of the description field chosen. So I could display the total amount at the bottom with only showing the description fields as the selectors.