Solved Row Source Column (1 Viewer)

[swingline]

I have a combo boxed with this query as the row source.

SELECT tblApprovedCourses.CourseName, tblApprovedCourses.NumberTD, tblApprovedCourses.CourseID FROM tblApprovedCourses;

I have an after update set to

Private Sub CourseName_AfterUpdate()
Me.NumTD.Value = Me.CourseName.Column(1)
Me.CourseID.Value = Me.CourseName.Column(2)
End Sub

The issue Im running into is that Column(2) isn't outputting anything thing to the desired text box. When I look at the query in the datasheet view its populated with the correct values.

 

[arnelgp]

what Data type is CourseID, numeric?
if so you need to Cast Column(2) as Long:

Me.CourseID.Value = Clng(Me.CourseName.Column(2))

 

[swingline]

CourseID is text

 

[swingline]

Got it working. I needed to change the format of the combo box

Column Count 3
Column Widths 2.5";0";0"