Quite new to vb am working my way through peter wright's beginning vb 6. On page 491 in the database section you can add a find next button. it uses the code

adodc1.recordset.find "[Year Published] = " & txtFindYear, 1

I am not following the books examples instead using the examples to create my own programs.

I am creating a small customer database.

I need to create a search button to find next surname.

I used the code

adodc1.recordset.find "[Customer Surname] = " & txtFindName, 1

but i receive the error message

run-time error '3001';

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

The first line of code seems to work fine with numbers but not with text.

Is there something missing for text?

text needs to be surrounded with single quote ' so try:
why are you "just starting" with vb6? vb.net is the latest.

Likely because, like myself, they *OWN* VB 6, and don't have the 550$ to shell out for VB.Net?

thanks for help code works fine now.