how do i retrieve value from table to a text box on a form

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

Guest

I am an Access novice however, I am attempting to retrieve a value from a two
field product table. (Product & Price) I have variable prodcut data placed
in a textbox by user button selections. I had hoped to figure out how to use
that data to match the product field in a table and retrieve the price. Is
there a way to pass this variable to a SQL query or something?
 
What is the key of your product table? The key is how you normally find
records in a table.
To locate records you would place a combo box on your screen that will list
all the products. The user can then pick one and the appropriate price then
becomes available.
You don't normally select records by 'button selections'.

Dorian
 
Back
Top