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