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?