Text Box

  • Thread starter Thread starter George
  • Start date Start date
G

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
 
George said:
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
Click to expand...

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)
 
Back
Top