Clear source object on subform back to unbound

[steve1111]

Hello,

I have a listbox "lbxMP" that holds names of forms and a subform "ctrlMP" that opens selected form (ctrlMP.sourceobject = lbxMP). I also have some various master cbx that control criteria in each form. I am trying to create a button that will not only clear/null all the cbx values (which works fine), but I am having a hard time telling me.ctrlMP to go back to null or unbound (i want it to blank out the subform to make it look fresh). I have tried requry and also me.ctrlMP = null and ctrlMP=unbound with no luck.

I appreciate any tips. - Thanks

 

[steve1111]

just tried something and solved it.
I needed to tell the lbxMP to go null and then me.ctrl.sourceobject = null. I thought i was close when i posted this, hope it can help someone in the future.