Yes, that worked! thanks. Now I have another issue related to this.
I have my main form called: F_workspacePP
Then I have a Tab control called: TabMain
I then created a subform called: SubFrmPPTab5 (I put this subform in Tab5 of the TabMain)
Inside the subform called (SubFrmPPTab5), I have a Tab Control called: SubTab
On the first tab called Tab1 of SubTab, I have a subform called: SubFrmTab05PP
I don't want SubFrmTab05PP to open with the record source filled in until I click on Tab1. So I am filling in the recordsource when they click the tab and when they close the main form, I am clearing the recordsource. What is the syntax for getting to the recordsource?
I have something like this for another tab without the tab control within a tab control:
Forms!F_workspacePP.[SubFrmTab02PBD].Form.RecordSource = ""
I tried chaning it to work on the one that has a tab control within a tab control to this:
Forms!F_workspacePP.[SubFrmPPTab5].Form.SubFrmTab5PP.RecordSource = ""
Is this correct?