• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 173
  • Last Modified:

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.
0
Matt Olson
Asked:
Matt Olson
1 Solution
 
als315Commented:
Look at sample Northwind database, which is included in Access.
Could you give tables structure and expected result (in Excel, for example)?
0
 
GRayLCommented:
"as a combo box for all three tables"  -  maybe a combo box for each of the three tables?
0
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.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now