Updating a table from a textbox on a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables, call them table A and table B. I have a form that has a
multi-column combo box and two text boxes. When the user selects the combo
box entry it updates the text boxes which are bound to the columns of the
multi-combo record. I want the form to output table B but it only outputs the
combo field data not the text data. I searched the discussions and tried
everything applicable and nothing is working. Any help is appreciated.
 
When the user selects the combo
box entry it updates the text boxes which are bound to the columns of the
multi-combo record.
Click to expand...

you can't "bind" a control to a column of a combo box control. i'm guessing
that you mean you set the ControlSource of your to textbox control to
=MyComboBox.Column(n)

that's not a bound textbox control, it's a calculated control. by
definition, a calculated control is UNbound, meaning that the data displayed
in it is not saved to the form's underlying table. if you want to bind your
textbox controls to fields in the form's RecordSource, and have the data in
those controls saved into the underlying table, you'll need to write code to
set the value of the textboxes.
I want the form to output table B but it only outputs the
combo field data not the text data.
Click to expand...

i don't understand this statement. can you clarify what you're doing, or
trying to do, here?

hth
 
Back
Top