Help with subform, again

[Nathan Guill]

Well, I was able to test for the parent, but how do I unbind the
sourceobject in a subform while the form is open? Basically, I want to be
able to "close" the subform. Is this possible?

 

[Damon Heron]

How about changing sourceobject and then just making it invisible?

Me.subContinuousSubform.SourceObject = ""
Me.subContinuousSubform.Visible = False


Damon

 

[Nathan Guill]

Duh, I'm sorry. In my code, I had the wrong name for the subform control.
I had sfrm in the code, but the control was named sbfSb. I changed that and
it works like it should.

 

[Marshall Barton]

Well, I was able to test for the parent, but how do I unbind the
sourceobject in a subform while the form is open? Basically, I want to be
able to "close" the subform.

Use a line of code to clear the subform's SourceObject
property:

Me.subform.SourceObject = ""

You may (or may not) want to also make the subform
invisible:

Me.subform.Visible = False