Auto Populate fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am stuck. I have a subform that lets the user choose from a table of
thousands of products. For each product, there are four packaging options
(FLW, FLQD, FL40, FL40C). Each packaging option has a different price. This
is what I would like to do:

A. User chooses a product from the list
B. User chooses a packaging option.
C. Access populates the correct price.

Thank you in advance!

EG
 
I am stuck. I have a subform that lets the user choose from a table of
thousands of products. For each product, there are four packaging options
(FLW, FLQD, FL40, FL40C). Each packaging option has a different price. This
is what I would like to do:

A. User chooses a product from the list
B. User chooses a packaging option.
C. Access populates the correct price.

Thank you in advance!

EG
Click to expand...

Sounds like you'll need a three-field Prices table with fields
ProductID, PackagingOption, and Price; join it to your subform's table
using a query joining on the first two fields to pick up the (current)
price.

John W. Vinson[MVP]
 
Back
Top