Find method in the ADO recordset

[dbrooks74]

I can't seem to get this to work, can anyone help?

'dePayroll.rscmdEmployee.Find "empLastName = 'ROY'", , adSearchForward, adBookmarkFirst
dePayroll.rscmdEmployee.Find "empLastName = '" & txtEmpLastName & "'", , adSearchForward, adBookmarkFirst

The first line works fine but when I try to use the second line and put "ROY" in the txtEmpLastName text box it doesn't do anything, any ideas? Thanks.

 

[Foada]

Try this

adSearchForward, adBookmarkFirst
dePayroll.rscmdEmployee.MoveFirst
dePayroll.rscmdEmployee.Find "empLastName = '" & txtEmpLastName & "'", , adSearchForward, adBookmarkFirst
Anything is possible, the problem is I only have one lifetime.

 

[dbrooks74]

I tried that, however that didn't change anything since I was already on the first record in my recordset. -db

 

[rdavis]

Is this the exact line?

dePayroll.rscmdEmployee.Find "empLastName = '" & txtEmpLastName & "'", , adSearchForward, adBookmarkFirst

If it is try this
dePayroll.rscmdEmployee.Find "empLastName = '" & txtEmpLastName.text & "'", , adSearchForward, adBookmarkFirst