Findfirst Problem 2

[desperatemeasures]

Hi

Can anyone help me with the following problem I am having using firdfirst. My code is the following:

.FindFirst "[Order Catalogue Id] = '" & OrderCat & "'"

In the table, [Order Catalogue Id] is an autonumber
OrderCat is an integer variable I have declared and gets its value from the form:

OrderCat = Me.[Order Catalogue Id]

It gives me the error "Run Time Error "3464" Data type mismatch in criteria expression"

I am not sure why I am getting the error.

 

[KenReay]

Hi

.FindFirst "[Order Catalogue Id] = " & OrderCat

If the column is numeric, you do not need the quotes, these are only needed for strings

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[desperatemeasures]

Thank you so much, solved my problem