Combo box and text box ref 1

[acarr2032]

I have a table that has 2 fields in it, the first one is the chemical and the second is the chemical number. On my form I have a combo box for a pull-down, right next to it I have a text box. Question is, how can I have it so when I pick a chemical from the combo box, have it fill in the chemical number text box next to it?

 

[RoyVidar]

Either in the after update event of the combo:

[tt]me!txtBox.value=me!cboCombo.column(1)[/tt]

or try the following controlsource of the text control:

[tt]=cboCombo.column(1)[/tt]

- replace with the names of your controls.

Roy-Vidar