getting a value in a table based on combo box selection in form

[ronytimm]

Hi,

can someone pls explain how I can update a field in a form based on a
combobox selection in that same field.
For example, if selection for a specfic product in the combo I want to get a
price in a table based on that product selection

thnx for your help

Grtz

 

[Ken Snell MVP]

If you have the combobox's RowSource query include the price value, you can
use the second example on this page:
http://www.mvps.org/access/forms/frm0058.htm


Or you can use a DLookup function in place of the combobox's .Column value,
where you look up the price based on the value in the combobox.

 

[John W. Vinson]

Hi,

can someone pls explain how I can update a field in a form based on a
combobox selection in that same field.
For example, if selection for a specfic product in the combo I want to get a
price in a table based on that product selection

thnx for your help

Grtz

This depends to a large extent on the structure of your tables... which we
cannot see. More details please?

 

[ronytimm]

Hi, Ken

Used your example to add the price on the rowsource query and then base the
price on the second column. Worked like a charm.
Thnx a lot!
Grtz

Rony