Solved

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

Posted on 2011-03-19
2
155 Views
Last Modified: 2012-05-11
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
Comment
Question by:mds_1
2 Comments
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
Comment Utility
Look at sample Northwind database, which is included in Access.
Could you give tables structure and expected result (in Excel, for example)?
0
 
LVL 44

Expert Comment

by:GRayL
Comment Utility
"as a combo box for all three tables"  -  maybe a combo box for each of the three tables?
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now