Help creating a variable/calculation field in a form in Access 2010.

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.
Matt OlsonDirector of ITAsked:
Who is Participating?
als315Connect With a Mentor Commented:
Look at sample Northwind database, which is included in Access.
Could you give tables structure and expected result (in Excel, for example)?
"as a combo box for all three tables"  -  maybe a combo box for each of the three tables?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.