Auto update on combo form field

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.
 
R

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)
 
R

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.
 
R

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top