textbox value based on combo

[NigelShaw]

Hi,

can anyone help? i need to have a textbox show a value from a table based on a combo box selection.
example:

combo box selects part i.e. laminate and the text box shows the price.


any help greatly appreciated.


regs,

NS

 

[pbaldy]

If it's just for display, make sure the data is included in the source of the combo, then have the textbox have a control source of:

=ComboName.Column(1)

Where 1 is the column the desired data is in (starts with 0).

 

[Sgt Bilkp]

Wrong post - sorry

 

[NigelShaw]

i dont quite follow you?

are you referring to yourself or not?

 

[Sgt Bilkp]

Spot on - many thanks