combo box and entering data

[Mike B]

I have a combo box that pulls three fields from one table. I want it to write data from one field to the main table that the record is associated with. For example, the form calculates an ROI for a marketing campaign. All of the data is entered into the main ROI table. I want the combo box data (just the one field out of three) to populate into that table (record). Any thoughts?

 

[fredg]

I have a combo box that pulls three fields from one table. I want
it to write data from one field to the main table that the record
is associated with. For example, the form calculates an ROI for a
marketing campaign. All of the data is entered into the main ROI
table. I want the combo box data (just the one field out of three)
to populate into that table (record). Any thoughts?

Include a text control bound to that field.

then code the Combo Box AfterUpdate event:
[ControlName] = Me!ComboName.Column(1)

The above assumes it's the 2nd column you want to send to the text
control. Combo Boxes are 0 based. Adjust the code accordingly.
Make sure the datatypes are correct.

 

[Jim Allensworth]

On Wed, 21 Jul 2004 11:21:03 -0700, =?Utf-8?B?TWlrZSBC?= <Mike

I have a combo box that pulls three fields from one table.
I want it to write data from one field to the main table that
the record is associated with. For example, the form calculates
an ROI for a marketing campaign. All of the data is entered into the
main ROI table. I want the combo box data (just the one field out of
three) to populate into that table (record). Any thoughts?

Can you not bind the combo box to to the field in question? It sounds
like the form is bound to a Record source of the the ROI table.

In the combo box set the Control Source property to the field that you
want it to go into. Set the Bound Column property to the column with
the info you want.

- Jim