deNorthWind.rscmdCustomers.Find using textfield in searchcriteria?

[stigejg]

Hello out there,

I need some help in a hurry. I am porogramming an example-program and and I cant figure out how to come round this problem.

I am trying to list some values out from the NorthWind-database and when I tryes to compile the program I get this errormessage:

”Run-time error 3001

The application is using wrong arguments that are of the wring type, are out of acceptable range, or are in conflict whit one another”

And the problem is that CustomerID are a text field in the database.

So what do I have to do to get this sentence to accept characters instead of numbers?

deNorthWind.rscmdCustomers.Find "CustomerID=" & strCustomerID

Anyone who can help me?

Kind regard Stig

 

[Sypher2]

Trying putting single quotes around it:

deNorthWind.rscmdCustomers.Find "CustomerID='" & strCustomerID & "'"

 

[stigejg]

Hi Sypher2

Thank you for the tip (I saw it my self the minit I hit the submit post button).

Stig