Lookup table data from Form

[Mik]

I have a table which contains two columns.
One column for Product type, and the other column for product price.
In addition, the form that i have created contains many fields, one is
a combo box which allows the user to select the product type.

What i want to do is .... when the user selects the product type from
the combo box, i want the product price to automatically display in
the adjacent box.

Can anybody please advise me?
I am obviously a beginner.

Mik.

 

[Arvin Meyer [MVP]]

You might try an Autolookup query, but for an AutoLookup to work, query the
query must be based on more than one table and the tables must have a
one-to-many relationship.

You can also use DLookup, or build a recordset. Look in your code window
helpfiles for details. Use those keywords and you should find examples.

 

[Mik]

You might try an Autolookup query, but for an AutoLookup to work, query the
query must be based on more than one table and the tables must have a
one-to-many relationship.

You can also use DLookup, or build a recordset. Look in your code window
helpfiles for details. Use those keywords and you should find examples.
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com









- Show quoted text -

Thanks for your help.
Got there in the end.
Mik