Combo Box to Text Field question.

R

Ronald_L

I need to know how to save the data from a text field to a particular field
in my database. The text field gets is data from the following control and
the correct data is displayed on the screen in that field.

=ContactNameBox.column(1)


How do I get the dispalyed data into a field called sSubmitEmail in my table.

Thanks for all your help.
 
A

Al Camp

Ronald,
Include the sSubmitEmail field on your form, and on the AfterUpdate event of your
ContactNameBox...
sSubmitEmail = ContactNameBox.Column(1)
Every time you slect a value in your combo, the associated Column(1) value will update
the sSubmitEMail field.
 
Top