Help Required!!!How to close a subform???

[Juggy]

Hi Boys and Gals,
I have a main form which has a subform within it. After data has been entered into the subform, I have added a command box on the subform which closes this subform down saves the data and goes back to the main form. I just wanted to know if anybody knew how to close a subform within a main form without using subform.visiable = false command???

If anybody has any ideas or coding on this area, I would appreaciate that alot!

Kind Regards

Juggy

 

[Mile-O]

Me.MySubForm.SourceObject = ""

 

[Juggy]

Thanks for the reply Mile,

There is an error occurring saying that 'Method or data member not found and it has highlighted Mysubform part from the Me.MySubForm.SourceObject = "" code which you gave me.

Can you give me an indication of what I need to do.

Sorry if this sounds stupid as I am a novice at Vba and access

Regards

Juggy

 

[Mile-O]

Change MySubForm to the name of your subform object.