Getting "3021" Error when using Recordset.find
Posted on 2005-04-26
I'm connecting to an .MDB file through ADO with VB6, and setting a DataGrid's datasource to my recordset.
I'm having a problem when using recordset.find.
If I try to search (using recordset.find) for a record that matches a record in the recordset located before the current record/cursor location, I get the following error:
"Run-time error '3021'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record."
So I can search successfully so long as the matching record is located *after* the currently selected record. When I search for a record located before the current one, I get the above error the moment I try and do something with the record...
I'm fairly new to DB programming with VB, and any help would be much appreciated... Thanks.