View Full Version : textbox value based on combo


NigelShaw
01-11-2008, 12:27 PM
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
01-11-2008, 01:02 PM
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
01-11-2008, 01:17 PM
Wrong post - sorry

NigelShaw
01-11-2008, 01:19 PM
i dont quite follow you?

are you referring to yourself or not?

Sgt Bilkp
01-11-2008, 01:21 PM
Spot on - many thanks