Automatically Fill in value in one field based on selection from combo box

[ballaterach]

I have a form with a combo box with 8 values in. I want to have a text box in the same form which will automatically be populated
with a value (price) based on the value selected from the combo box.

Simple answer would be good as I'm getting old

Thanks in advance!!

[lfpm062010]

In afterupdate event of the combo box,

me![TEXTBOX] = me![COMBOBOX].column(#) ' WHERE # is the column value that you want in the combobox minus 1 because of the combobox column counting start from 0

[ballaterach]

Hi thanks for your response; not trying to be smart but 'is the column value that you want in the combobox minus1...' should read 'is the column value that you want in the text box minus1...'
and do I need to replace 'me' with the name of my form? thank you sorry to sound stupid haven't used access for ages and its all gone from my head!!

In afterupdate event of the combo box,

me![TEXTBOX] = me![COMBOBOX].column(#) ' WHERE # is the column value that you want in the combobox minus 1 because of the combobox column counting start from 0

[Missinglinq]

'is the column value that you want in the combobox minus1...' should read 'is the column value that you want in the text box minus1...'

Yes; that was a typo.

do I need to replace 'me' with the name of my form

No; Me. is an alias for the current Form. If you have code in a Form's code module that says

Me.MyTextboxName

it is referring to a Control, on that Form, named MyTextboxName.

It's just a shortcut, if you will, that keeps you from continually typing a complete reference to the Form.

Linq ;0)>