Get value from other control not updating table

[1eye1vision]

Hi All.
I have in issue with a control on my form which gets its value from another control. However when this field is updated the value is not past to the table.
What i have at the moment in the control source is



=[cboShip].[Column](2)

Now this gets the data required from the control but does not pass to table.

Any help would be appreciated.

[alansidman]

Is your control that is getting the data bound to a field in your table? That would be the first thing I would look at.

alan

[John_G]

It does not put a value in the table because have not specified a table field as the control source. You have set the control source to an expression based on another control; in order to update the table you need to set the source for the control to the table field, and set it's value using VBA. My suggestion would be the After Update event of the combo box, something like this:

me!mycontrol = [cboShip].[Column](2), where mycontrol is the name of the textbox control.

HTH

John

[1eye1vision]

Thanks John G,
That worked a treat, i placed that in the After Update event of the control from which i was getting the Data. I then set the Control source of the control which was getting the data to the field from the table.

Great reply