For this example, assume a subform control name Sub1, and the code examples
are in the main form's module.

You can determine If Sub1 has no form loaded into it by testing its
SourceObject property:
   If Len(Me.Sub1.SourceObject) = 0 Then ...

If the subform control does have a SourceObject assigned, but there are no
records in the subform, you can examine the RecordCount of the
RecordsetClone of the Form in the subform control:
   If Me.Sub1.Form.RecordsetClone.RecordCount = 0 Then ...

Hi Chris.

I think that the following should do it for you.

if Me.[SubFormName].SourceObject <> "" then
    ' Do what ever you want now that you know that the Source Object is set
to a valid table or subform.
end if

Let me know if this isn't what you are referring to.

Lance

Chris,

Try:

if Me.[subFormName].SourceObject <> "" Then
  ' Perform task.
else
  ' Bind the appropriate table or subform
End if

I've done this quite a bit when switching dynamically betwee subforms.  You
can even enhance it with a DCount to ensure that there are records available
as well.

Let me know if you were looking for something else.

Lance