single column lookup with multile column return

  • Thread starter Thread starter Roger Ryall
  • Start date Start date
R

Roger Ryall

This is probabaly a simple thing but here goes. I have a 3 column table (ie.
ID, Product, Price. I am using a form with a look up (combo box) on product.
Once the product is selected how can i get to return the corresponding price
into another box on the form?
Thanks
 
Not sure i understand. I have only one table that i need to pull from so not
sure how joinning would help. The purpose is to automatically show a price on
a form based on picking the product from a drop down then adding the prices
together at bottum.
I dont have any VB experiance but very strong access 03/07 experiance
thx
 
Back
Top