I have a form that has a combo box. The row source of the combo box is a query with 3 fields. I also have a text box located to the right of the combo box. I would like the first item to the left in my combo box to show up in the actual combo box when selected. Then I want the value of the second field to be automatically placed in the text box. I had this working kind of when my text box was a list box and in the combo box code i put
Me.MyListBox.Requery
But this changed all of my records from that point on. Everytime I change the value in the combo box, the list box value changed for every record.
Please Help.
Me.MyListBox.Requery
But this changed all of my records from that point on. Everytime I change the value in the combo box, the list box value changed for every record.
Please Help.