Combo box error

[gronsky]

In a form I have several text boxes and one combo box.

When a selection is made from the combo box, column 0 is added to tblFinancial fldType and I would like column 1 to be added to tblFinacial fldDues.

In the AfterUpdate of the combo box(Combo26) I have;

Me![Dues] = Me![Combo(26)].Column(1)

But when testing, I get an error stating that "Access can't find the field 'Combo(26)' refered to in your expression"

Any help is greatly appreciated

 

[RobertT687]

Don't include Parenthesis around the name. Name should be [Combo26] not Combo(26).
Code should read:
Me![Dues] = Me![Combo26].Column(1)

 

[gronsky]

Hey RobertT687,

Thanks for the reply.
Removing the() did the trick, Thanks!