I've been searching this site for about 3 days now trying to get my problem solved. Here's the situation: I have a combo box that I want to populate 2 other text boxes. I got the column count down and everything else. It was working fine for the first text box, but didn't work for the second textbox. and now, I don't know what I did to stop it from working!!! I attached the Code (there are 2 different codes, as you can see).
For the first one (FirstName) the highlight is on "Me.LastName = Me.FirstName.Column(1)
For the second one (ProductDescription), the highlight is on "Me.Text29 = Me.ProductDescription.Colu
Please Help!!!! Thanks So Much!!
Private Sub FirstName_AfterUpdate()
If IsNull(Me.FirstName) Then Exit Sub
Me.LastName = Me.FirstName.Column(1)
Me.Extension = Me.FirstName.Column(2)
Private Sub ProductDescription_AfterUpdate()
If IsNull(Me.ProductDescription) Then Exit Sub
Me.UnitPrice = Me.ProductDescription.Column(1)
Me.Text29 = Me.ProductDescription.Column(2)