check if unbound form has recordset already dynamically bound to it

hey guys,

how do i check if an unbound form already has a recordset bound to it at runtime? thanks!! = ))

i tried this but to no avail = (

msgbox Me.subDetails.Form.Recordset is nothing

also tried

set varX =Me.subDetails.Form.Recordset
msgbox varX is nothing
Who is Participating?
IrogSintaConnect With a Mentor Commented:
MsgBox Me.subDetails.Form.RecordSource = ""
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
Or ...

If Me.subDetails.Form.RecordSource = "" Then
     ' No bound
End If

But I'm confused re:

" if an unbound form already has a recordset bound"

It can't be both ... either or ...
developingprogrammerAuthor Commented:
my goodness guys, i set the sourceobject to "" and i was testing for the sourceobject's recordset. can you believe it?? what madness!!

and i was assigning the recordset to the subform directly without using the recordsource so i thought the recordsource will be empty. but i just tested and even if i assign the recordset directly the recordsource will still have the query string.

thanks so much guys!! = ))
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.