Forms and Expressions

[Kelli]

I have a table that a worker will select certain items and from that i want
the cost column to autoppopulate teh cost for those selections.. ie: if a
case card, double sided and size is 21/42, the cost would be $7.00....

Can anyone help me with this?

 

[Jeanette Cunningham]

Hi Kelli,
I do this in an inventory app.
One way is to use a combo for the parts and include the cost as one of the
columns in the combo.
After user chooses a part, you can get the cost from the combo and set the
cost of the appropriate control to that value.

There is a sample database that shows how to do this - it is written for a
corner store selling bread and fruit, but the principle is the same.
As a bonus, this sample also shows how to allow the user to edit the cost
after they have chosen the part.

http://allenbrowne.com/TechniqueEnterCalcText.html



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia