single column lookup with multile column return

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
 
R

Roger Ryall

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup table data from Form 2
Loading a lookup field into a form 0
Add a column to Exsisting Form 1
default values in combo box with multiple colimns 1
Using the second column of a lookup field in row source 5
Form with a Lookup Table 1
filter query on combo box in a continuous subform 0
calculated field in a form 1

Top