Syntax of control on tab controls

[Tony Williams]

I have a form "frmturnover" on which there is asubform "subfrmturnover"
which has three tabcontrols say Page1, Page2 and Page3. There is control
"control2" on Page2 that when its is entered I want to check if it is the
same value as a control "control1" on Page1 and then show a pop up box if
they don't match. I can work out the code for the message box but I'm
getting a little lost on the syntax for referring to the controls on the
pages of the tab control.
I also want to check the value of Control2 on page2 with the vale of
control3 on a page1 of a subform "subfrmmain" on another form "frmmain"
can anyone point me in the right direction?
TIA
Tony Williams

[Pieter Linden]

"Tony Williams" <[e-mail]> wrote in message news:<co**********@sparta.btinternet.com>...

I have a form "frmturnover" on which there is asubform "subfrmturnover"
which has three tabcontrols say Page1, Page2 and Page3. There is control
"control2" on Page2 that when its is entered I want to check if it is the
same value as a control "control1" on Page1 and then show a pop up box if
they don't match. I can work out the code for the message box but I'm
getting a little lost on the syntax for referring to the controls on the
pages of the tab control.
I also want to check the value of Control2 on page2 with the vale of
control3 on a page1 of a subform "subfrmmain" on another form "frmmain"
can anyone point me in the right direction?
TIA
Tony Williams

Keri Hardwick wrote an article about this a while back. It's on
Access Web in the forms section...
http://www.mvps.org/access/forms/frm0025.htm

if that doesn't do it, try this one.
http://www.mvps.org/access/forms/frm0031.htm

[Tony Williams]

Thanks Peter that's just what I needed!
Tony
"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf**************************@posting.google.c om...

"Tony Williams" <[e-mail]> wrote in message

news:<co**********@sparta.btinternet.com>...

I have a form "frmturnover" on which there is asubform "subfrmturnover"
which has three tabcontrols say Page1, Page2 and Page3. There is control
"control2" on Page2 that when its is entered I want to check if it is the same value as a control "control1" on Page1 and then show a pop up box if they don't match. I can work out the code for the message box but I'm
getting a little lost on the syntax for referring to the controls on the
pages of the tab control.
I also want to check the value of Control2 on page2 with the vale of
control3 on a page1 of a subform "subfrmmain" on another form "frmmain"
can anyone point me in the right direction?
TIA
Tony Williams

Keri Hardwick wrote an article about this a while back. It's on
Access Web in the forms section...
http://www.mvps.org/access/forms/frm0025.htm

if that doesn't do it, try this one.
http://www.mvps.org/access/forms/frm0031.htm