I have a combo box that is populated by a query and returns 3 columns - this is shown in the query result editor and consists of one number field (column 0) and two date fields columns 1 and 2.
I then have an after update event to populate two text boxes as follows:-
Private Sub Combo56_AfterUpdate()
Me.Text59 = Me.Combo56.Column(1)
Me.Text65 = Me.Combo56.Column(2)
Text59 populates but Text65 does not - Only columns 0 and 1 are available and I can populate the two boxes with columns 0 and 1but column(2) is not returning.
The row source looks like this:-
ORDER BY FinancialYear.FinancialYear;