Save Combobox results to Table

[Kinder0177]

I've currently got a combobox that populates several empty field on my form. The Combo is pointed at the ExternalContractor_T however i want to save one of the newly populated fields to the table that my form is pointed at.
I've tryed:

Me.ID = Me.Combo1(0)

and the code i use to populate my fields is e.g



=[Combobox].[Combo1](0)

Is this possible and if so how can i do it?

[RuralGuy]

Use the ComboBox's AfterUpdate event to populate the other *bound* controls instead of putting a formula in the ControlSource of those other controls.

[Kinder0177]

Thanks but i'm quite a novice at Access and i'm unsure what you mean.

[RuralGuy]

If you have: Me.YourTextBox = Me.ComboBoxName.Column(0) in the afterUpdate event of the ComboBox then when you make a selection in the ComboBox, the YourTextBox control on your form will get the value of the 1st column in the RowSource of the ComboBox. Of course you would need to use the names of your controls for this to happen.

[Kinder0177]

Perhaps I didnt explain properly but i've already tried that and it will work when i first try then it comes up with the debug error.

[RuralGuy]

What debug error?