Updating table from TextBox

[Sharon]

Hopefully this question will be clear. I have created a
form that uses a combo box to choose a state & then a
text box on that same form gets auto-populated with a
Region #... which works great (thanks to help from
mvps.org). However, I would also like to populate my
table with that Region Code. But, since the control (the
place I usually put the info) is set to
=cboWorkState.Column(2) [to pull in the Region #], I can't
figure out how to put that value in the underlying table.
Can someone please assist me?

Thanks so much!
Sharon

 

[Rick Brandt]

Hopefully this question will be clear. I have created a
form that uses a combo box to choose a state & then a
text box on that same form gets auto-populated with a
Region #... which works great (thanks to help from
mvps.org). However, I would also like to populate my
table with that Region Code. But, since the control (the
place I usually put the info) is set to
=cboWorkState.Column(2) [to pull in the Region #], I can't
figure out how to put that value in the underlying table.
Can someone please assist me?

Change the ControlSource of the TextBox to the field name you want the value stored
in. Then use code in the AfterUpdate event of the ComboBox to "push" the third
column value into the TextBox.

Me![Region Code] = Me!cboWorkState.Column(2)