ok it should be easy enough but...

i used the find method before on numerical fields - no problem

now i got a field called Code with a format like xyz999f.
everytime i try to 'find' something i get an error telling me that my criteria is not of the correct type even if i enter the exact value of the current record.

This is what i did:

rstBio.Find "Code = AAA286F"

result: error 3001

tried also:

rstBio.Find "Code = AAA286F")

result: error 3001

and:

rstBio.Find("Code = 'AAA286F'"

result: no error but also no record found although AAA286F exists



it's the first field in the set. i got the following info about fields(0)

.name = "code"
.type = 202
.value ="AAA286F"

in the end i would like to search for the recordset that corresponds to the 'Code' a user picks from a combobox...
and set this as the current record of the recordset all my textboxes are linked to.
I hope find is a good method and if so how do i use it???
I checked the msdn and a book and tried and...

thx,

Helger