How can I get table data into a text box

[Guest]

I would like to be able to pass variable data (product name) from a Textbox
on a form to query data in a Table and then have that query return the
(price) value into another textbox on the form. I really wanted to automate
this task rather than having the user select and store the (price) from a
combobox. Is there a way to do this that I cannot find or do you have a
suggestion of a different approach to obtain the same result?

 

[tina]

take a look at the DLookup() function. you can use it to return a single
value, like a price, from a table and use VBA code or a macro to set the
value of the form's control.

hth