Subforms on Tab Controls

  • Thread starter Thread starter BBM
  • Start date Start date
B

BBM

What is the full identifier of a control on a subform that
resides on a page of a tab control?

On the same tab control there are other pages that also
contain subforms. I assume that they are all "live" when
I load the main form that contains the tab control. That
is, I can refer to values on other pages by using the full
identifier of the control that contains the value on the
other page. True?
 
BBM said:
What is the full identifier of a control on a subform that
resides on a page of a tab control?

On the same tab control there are other pages that also
contain subforms. I assume that they are all "live" when
I load the main form that contains the tab control. That
is, I can refer to values on other pages by using the full
identifier of the control that contains the value on the
other page. True?
Click to expand...

TabControls are merely an organizational tool for your Form's real estate. They
do not affect control reference syntax at all.
 
Hello,

Thanks for your post. If I understand correctly that you want to refer to
the controls in subform. Please check the suggestions in the following
article to see if it meets your requirements.

This article describes how to refer to controls on subforms or subreports,
and describes some common problems you may encounter when you refer to
controls on subforms or subreports.
113352 ACC: How to Refer to a Control on a Subform or Subreport
http://support.microsoft.com/?id=113352

I am looking forward to hearing from you soon.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
 
-----Original Message-----


TabControls are merely an organizational tool for your Form's real estate. They
do not affect control reference syntax at all.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.
Thanks. I suspected this but couldn't find it in the doc.
Click to expand...

BBM
 
-----Original Message-----
Hello,

Thanks for your post. If I understand correctly that you want to refer to
the controls in subform. Please check the suggestions in the following
article to see if it meets your requirements.

This article describes how to refer to controls on subforms or subreports,
and describes some common problems you may encounter when you refer to
controls on subforms or subreports.
113352 ACC: How to Refer to a Control on a Subform or Subreport
http://support.microsoft.com/?id=113352

I am looking forward to hearing from you soon.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

.
Thanks for your help. By the way, is Access 97 the ONLY
Click to expand...
version of Access that lets you eliminate the "Form"
reference when referencing the subform control? Ie.

Forms![Main Form]![Sub Form]![Subform Control]

instead of...

Forms![Main Form]![Sub Form].Form![Subform Control]

I'm using Access 2003, but I have a book on 97 and it says
you can do this. The KB article you referenced says you
can do this for 97 but doesn't mention any other version
specific information.
 
Hello,

Thanks for your update. Based on my test, you can use the following
statement to refer to controls in subform in Access 2003.

Forms![Main Form]![Sub Form]![Subform Control]

I also found a related article, which is for Access 2000. I think this
article also applies to Access 2003.
209099 ACC2000: How to Refer to a Control on a Subform or Subreport
http://support.microsoft.com/?id=209099

Best regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
 
Thanks. That clears it up. Your previous post solved my
problem which was that I was trying to reference a
property of the subform itself without using the "Form"
reference below the subform name. I was curious about
the "shortcut" syntax though.
 
Back
Top