Error 3021

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form entry where user enters data in the form of combo box and text box. This was working fine but now I am getting an error saying "No current record. (Error 3021)"
This error occurs after the unsuccessful application of one of the Find methods or the Seek method, when the underlying Recordset contains no records or the record has been deleted. Move to or select another record, and try the operation again. If the Recordset is empty, you cannot position to a current record. Check the BOF and EOF properties
How can I resolve this issue
Thank
Shaj
 
If this is Access 2002, and the error began showing up only after you
applied Service Pack 3 for Office XP, it is a known problem. AFAIK, the
current workaround is to just use error handling to ignore the error in the
limited cases where it fires.

The error can also occur after a FindFirst, and the solution is to check the
NoMatch property before you try to work with the record. You may also get
the error after opening or filtering a recordset that has no records, and
the solution would be to check RecordCount or BOF/EOF.

Post back with more detail if that does not address what you are
experiencing.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Shaji Alexander said:
I have a form entry where user enters data in the form of combo box and
Click to expand...
text box. This was working fine but now I am getting an error saying "No
current record. (Error 3021)"
This error occurs after the unsuccessful application of one of the Find
Click to expand...
methods or the Seek method, when the underlying Recordset contains no
records or the record has been deleted. Move to or select another record,
and try the operation again. If the Recordset is empty, you cannot position
to a current record. Check the BOF and EOF properties.
 
Back
Top