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

 

[pbaldy]

Can't look at the sample right now, but does this help?

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

 

[JHB]

...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

Remove the 2 single quotes marked by red.

rstCust.FindFirst "fldCustomerID = [COLOR=Red][B]'[/B][/COLOR]" & lstFindCus & "[B][COLOR=Red]'[/COLOR][/B]"

Correct is:

rstCust.FindFirst "fldCustomerID = " & lstFindCus

 

[cc.caroline15]

Thank you so much!! never imagined those quotes were the cause of the problem..!!

Remove the 2 single quotes marked by red.

rstCust.FindFirst "fldCustomerID = [COLOR=red][B]'[/B][/COLOR]" & lstFindCus & "[B][COLOR=red]'[/COLOR][/B]"

Correct is:

rstCust.FindFirst "fldCustomerID = " & lstFindCus

 

[JHB]

That is what "3464 data type mismatch" means!
The "fldCustomerID" is a number type field and with the 2 single quotes around the "lstFindCus", it gets as string.