I don't have much in the way of coding skills, so hang in there with me... I have a form. I have a combo box in that form with a number of fields. The problem is, when I select something from the drop down only some of the fields update in the form. I either have to refresh manually, or leave and return to the record to see all of my fields.
My current code is:
Private Sub Combo70_AfterUpdate()
Me.FIRSTNAME = Me.Combo70.Column(2)
Me.Profession = Me.Combo70.Column(3)
Me.NPI = Me.Combo70.Column(4)
Me.LIC = Me.Combo70.Column(5)
Me.LICState = Me.Combo70.Column(6)
Me.ADDRESS1 = Me.Combo70.Column(7)
Me.Address2 = Me.Combo70.Column(8)
Me.City = Me.Combo70.Column(9)
Me.State = Me.Combo70.Column(10)
Me.Zip = Me.Combo70.Column(11)
Me.EMAILADD = Me.Combo70.Column(12)
Me.PHONe = Me.Combo70.Column(13)
Me.SURGEON = Me.Combo70.Column(14)
End Sub
Can someone give me some code or a tip to have everything refresh when I select something from the drop down?
Thanks!
My current code is:
Private Sub Combo70_AfterUpdate()
Me.FIRSTNAME = Me.Combo70.Column(2)
Me.Profession = Me.Combo70.Column(3)
Me.NPI = Me.Combo70.Column(4)
Me.LIC = Me.Combo70.Column(5)
Me.LICState = Me.Combo70.Column(6)
Me.ADDRESS1 = Me.Combo70.Column(7)
Me.Address2 = Me.Combo70.Column(8)
Me.City = Me.Combo70.Column(9)
Me.State = Me.Combo70.Column(10)
Me.Zip = Me.Combo70.Column(11)
Me.EMAILADD = Me.Combo70.Column(12)
Me.PHONe = Me.Combo70.Column(13)
Me.SURGEON = Me.Combo70.Column(14)
End Sub
Can someone give me some code or a tip to have everything refresh when I select something from the drop down?
Thanks!