Text Box

[George]

On my form one of the fields gets automatically filled in
by getting its value from a combo Box. Is there a way to
send that field's value to the Table that created the form.
Thanks - George

 

[Rick Brandt]

On my form one of the fields gets automatically filled in
by getting its value from a combo Box. Is there a way to
send that field's value to the Table that created the form.
Thanks - George

Instead of a ControlSource like. . .

[ComboBoxName].Column(n)

Use a ControlSource that is the name of the field in the table you want to store
the value in. Then in the AfterUpdate event of the ComboBox have code similar
to. . .

Me![ControlName] = Me![ComboBoxName].Column(n)