oRS.Find syntax 1

[mot98]

Hi all,

I am trying to use the Find method to search the database. However I am getting some strange errors on it.

I am searching a Column in the database that is called "Book Code"

The syntax looks like this:

oRSb.find "Book Code = '" & varCode & "'"

Is there a problem with a column name that is 2 words?

Any help would be appreciated...
mot98


"Every day I learn something new, and forget 10 things I learned long ago!"

 

[cbokowski]

surround book code in [ ] square brackets.

 

[mot98]

Thanks cbokowski..that worked great. mot98


"Every day I learn something new, and forget 10 things I learned long ago!"