If record not found

CCIDBMNG

Registered User.
Local time
Today, 08:18
Joined
Jan 25, 2002
Messages
154
I'm using the the findfirst method to bookmark a record. Can someone tell me the code to say if the record is not found? I know I've seen it some where on here before but I can't find it now. Thanks.
 
After your find first, execute

If rs.NoMatch then
-add your code for no matching records
end if

"rs" is your recordset.
 
Thank you that worked perfect.
 

Users who are viewing this thread

Back
Top Bottom