Tab control references

[Guest]

Hello,

I am trying to change my large single form into a tabbed form.
I moved all my form elements to various tabs, but a query pointing to the
former main form is no longer working.
I suspect I need to point to towards the tab in my tab control where the
field it needs to look up resides now.

The query's where statement used to be as follows:

WHERE
(((tblActivity.ActivityID)=Forms!frmActivityApplicationForm!ActivityID));

Now, frmActivityApplicationForm is hosting the tab control TabbedMenu, and
my text box is on tab "Page 1".

How do I update my statement so that the query works again?

Thank you.

 

[ruralguy via AccessMonster.com]

Your problem is elsewhere because a tab control does not affect the
referencing of controls. They are referenced as if the tab control is not
even there.

 

[Douglas J. Steele]

No, you don't need to include the tab control in that: each control on the
form has to have a unique name, regardless of the tab, so it's not required.

Double-check that you didn't somehow change the name of the control on the
tab.

 

[Guest]

Ok, thank you for your insight.

It's working now.
I swear I didn't change anything though.
Oh well.
Thanks again.