D
Don
I have a table called tblCUSTOMER with 3 fields: CUST_NO, CUSTOMER, ROUTE_NO.
I have a form with 3 unbound text boxes: txtCUST_NO, txtCUSTOMER,
txtROUTE_NO. Using the afterupdate event property, I want to populate
txtCUSTOMER and txtROUTE_NO when I key in the customer number in the
txtCUST_NO field.
When I enter a customer number in the text box, I get the following error:
Data type mismatch in criteria expression. (Error 3464)
The criteria expression in a Find method is attempting to compare a field
with a value whose data type does not match the field’s data type.
The DLookup was written as such - can anyone help me?
Private Sub txtCUST_NO_AfterUpdate()
Me.txtCUSTOMER = DLookup("[CUSTOMER]", "tblCUSTOMER", "[CUST_NO] =" _
& Forms![frmERROR_HEADER]!txtCUST_NO)
End Sub
I have a form with 3 unbound text boxes: txtCUST_NO, txtCUSTOMER,
txtROUTE_NO. Using the afterupdate event property, I want to populate
txtCUSTOMER and txtROUTE_NO when I key in the customer number in the
txtCUST_NO field.
When I enter a customer number in the text box, I get the following error:
Data type mismatch in criteria expression. (Error 3464)
The criteria expression in a Find method is attempting to compare a field
with a value whose data type does not match the field’s data type.
The DLookup was written as such - can anyone help me?
Private Sub txtCUST_NO_AfterUpdate()
Me.txtCUSTOMER = DLookup("[CUSTOMER]", "tblCUSTOMER", "[CUST_NO] =" _
& Forms![frmERROR_HEADER]!txtCUST_NO)
End Sub