• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

access on update query columns are missing

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)
Me.Combo56.Requery
End Sub

Open in new window



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:-
SELECT FinancialYear.FinancialYear,
FinancialYear.FinYearStartDate,
 FinancialYear.FinYearEndDate 
FROM FinancialYear 
ORDER BY FinancialYear.FinancialYear; 

Open in new window

0
owenja
Asked:
owenja
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You must also insure that your Combo's ColumnCount and such are set correctly. For 3 columns, you'd have something like this:

ColumnCount = 3
ColumnWidths=0;1;1

That would hide the first one, and show the second two.
0
 
owenjaAuthor Commented:
Thank you - perfect answer
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now