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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bayshore - 30 Nov 2005 16:15 GMT

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?

Reply to this Message

mscertified - 30 Nov 2005 17:30 GMT

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

> 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
[quoted text clipped - 3 lines]
>
>

Reply to this Message