I have a combo box that contains a drop down of customer id’s. When a user selects a customer ID, I want to use that get the city and put it in a text box. I have the following code on the after update code on the customer ID field:
Private Sub Custid_AfterUpdate()
City = DLookup("[City ]", "Customer", "[CustID ] = '" & Me!Custid& "'")
End Sub
I get the data type mismatch in criteria expression error. I did check and &Me!Custid is displaying the correct value.
Any ideas as to what I am doing wrong?
Thanks!