Auto update on combo form field

  • Thread starter Thread starter Raven
  • Start date Start date
R

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.
 
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.
 
Back
Top