Updating a table from a textbox on a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe Banach - 25 Oct 2005 02:14 GMT

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.

Reply to this Message

tina - 25 Oct 2005 03:40 GMT

> When the user selects the combo
> box entry it updates the text boxes which are bound to the columns of the
> multi-combo record.

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.

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

hth

> 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.

Reply to this Message