Lookup table data from Form

  • Thread starter Thread starter Mik
  • Start date Start date
M

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.
 
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.
 
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 -
Click to expand...

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