Record Set Null

[Sash]

I have a bunch of code that runs, but I want to prompt the user and not run
it if there are no records found.

Thought I could do something like, whereby rs is the recordset:

If IsNull(rs) Then
MsgBox "No Records Found"
db.Close
End If

 

[Maurice]

assuming you have set a recordset you can use something like:

with rs
if not .BOF and not .EOF then
'do your stuff here
else
'if you get here there will be no records so put your cancellation here.
end if
end with

hth

 

[Alex Dybenko]

also check rs.NoMatch, if FindFirst method was used

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com