Auto update on combo form field

[Raven]

I am trying to auto populate 3 fields on my UserReport form on the UserID
combo box using the After Update event. The row source is from an employee's
table. I am using the following codes:

Me.EmpID = Me.UserID = UserID.Column(2)
Me.LanID = Me.UserID = UserID.Column(3)
Me.Title = Me.UserID = UserId.Column(4)

When I click on the UserID field's dropdown list of names, my empid and
lanid populates as 0

The form's source table has the UserID listed as number data type.

Your support is greatly appreciated.

 

[ruralguy via AccessMonster.com]

Have you tried:
Me.EmpID = Me.UserID.Column(2)
Me.LanID = Me.UserID.Column(3)
Me.Title = Me.UserID.Column(4)

 

[Raven]

Yes, right aftter I sent this post. I noticed I had added more info to the
argument than was required. Thank you for your reponse.

 

[ruralguy via AccessMonster.com]

Excellent and you are welcome.

Yes, right aftter I sent this post. I noticed I had added more info to the
argument than was required. Thank you for your reponse.

Have you tried:
Me.EmpID = Me.UserID.Column(2)

[quoted text clipped - 15 lines]