how to handle 'no current record' error in seek method (DAO)

The seek method of the tabletype recordset of the DAO pops up a message box saying "no current record" if no matches are found for the given search criteria.


How, if at all possible, can i stop this message box from appearing when there is no match for the given criteria ??

I don't know when it returns error. But there are two possiblities

1) Seek statement itself returns error.

if this is true then add on error to trap error

2) if error occurs while accessing records TableObject.Nomatch must be true


one of these will work