Run Time error 3464

[cc.caroline15]

Hello everyone on my database I have a form named frmGoToRecordDialog when I
select a customer and click show record it should open frmCustomers on that
record of the customer selected but instead I get run time error 3464 data type


mismatch in criteria expression. Can anyone please help me? thank you 242CCA_A05.zip

[pbaldy]

Was this not helpful? That error usually means you've used the wrong syntax for the data type.

http://www.baldyweb.com/wherecondition.htm

[cc.caroline15]

Hi pbaldy
I read your article and check my code but my sintax seems correct to me here is the code I'm a newbie so I might be missing something that you might be able to catch

Private Sub cmdShowRecord_Click()
DoCmd.OpenForm "frmCustomers", acNormal
'declare recordset to hold customer records
Dim rstCust As DAO.Recordset
'load recordset
Set rstCust = Forms!frmCustomers.RecordsetClone
'match EmpID with FindEmp ID
rstCust.FindFirst "fldCustomerID = '" & lstFindCus & "'"
'go to the record
Forms!frmCustomers.Bookmark = rstCust.Bookmark
'close the dialog
DoCmd.Close acForm, "frmGoToRecordDialog"
  
End Sub

Thank you

[pbaldy]

What is the data type of the field? If it's numeric try:

rstCust.FindFirst "fldCustomerID = " & lstFindCus

[cc.caroline15]

I didn't know the quotes had something to do with the numeric type! I was very confused because I thought it only applied to text and date.. Thank you

[pbaldy]

Happy to help.