Test for Recordset = Nothing?

DagJ

New Member

Join Date: Nov 2012

Posts: 2
#1

Test for Recordset = Nothing?

Nov 1 '12, 09:54 AM

Sorry folks, none of the suggestions above (not even the claimed failsafe ones) will work if the recordset is set to Nothing.
How do you test for that?
Tags: None
TheSmileyCoder

Recognized Expert Moderator Top Contributor

Join Date: Dec 2009

Posts: 2322
#2

Nov 1 '12, 10:12 AM

What suggestions above?????

Code:

Dim rs as Dao.Recordset If rs is Nothing then Msgbox "Recordset is set to nothing" End If
Comment

Comment