Confused by subform naming conventions 3

[kupe]

The form “frmMatrix” has two subforms. First is subform “frmWorkers”, and the second subform is “frmTransfers”.

To email, and to print a document (via Word) from the db, I need to refer to fields on the Form, and the SubForm “frmWorkers”.

Advice from Microsoft says I have to refer to subform controls and then controls. After an hour or two of various attempts, I’m left puzzled and answerless.

Most obliged if an expert could tell me how these two fields should be described:

1. frmMatrix.txtSName, and
2. frmWorkers.cboWork

I mean, should it be Forms!frmMatrix.txtSName and Forms!frmMatrix.frmWorkers.cboWork ? - though this doesn’t work.

 

[PHV]

My guess (provided frmMatrix is an open mainform):
Forms!frmMatrix!txtSName
Forms!frmMatrix!frmWorkers.Form!cboWork

Have a look here:

http://support.microsoft.com/?kbid=209099

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kupe]

Thanks, PHV, I'll try that. (Should the last Form be Forms! plural?

Thanks for the ulr. But that is far from clear - to me, and my limited experience, that is. I've wasted hours trying to make sense of it.

Cheers

 

[PHV]

Another way is to follow the Expression Builder (loaded forms ...).

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kupe]

Hi PH
When I say 'far from clear' I mean Microsoft's contribution!
Cheers

 

[Eupher]

Here's another link, maybe this will help:

http://www.mvps.org/access/forms/frm0031.htm

Ken S.

 

[Eupher]

Or, maybe this:

When you place a subform on your form, you are placing a subform control. That control has various properties, methods, and events. One of its properties is the actual form that is associated with it. So when you are on the main form and want to refer to properties or controls of the subform, it is not enough to refer just to the subform control (because the control is a separate entity). You must refer to the Form property of the subform control before you can reference the actual subform's objects, i.e.:

Me![blue]SubformControlName[/blue].[purple]Form[/purple]![blue]NameOfControlOnSubform[/blue]

Or...

Me![blue]SubformControlName[/blue].[purple]Form[/purple].[purple]SubformProperty[/purple]

Or...

Me![blue]SubformControlName[/blue].[purple]Form[/purple]![blue]NameOfControlOnSubform[/blue].[purple]PropertyOfControlOnSubform[/purple]

HTH,

Ken S.

 

[kupe]

PH
Your guess works really well, PH. Thank you. Very much obliged to you.

Thanks, Ken S, for the url and for explaining. I confess that when I have to find a quick answer, finding what is a Name of Control and what is a Property of ControlOnSubform confusing.

Going by PHV's code, SubformControlName is the name of the form.

NameOfControlOnSubform must be txtSomething.

But then what is a PropertyOfControlOnSubform?

When in haste one looks at the form Properties, these parts of the form are not named that way. Well, at this present stage, I find it a bit confusing. Perhaps after a while, the smoke clears.

 

[Eupher]

Hi, kupe:

If you use the subform wizard to place your subform control, by default the name of the subform control and the name of the actual (sub)form to which the control is bound are indeed the same. But this is NOT NECESSARILY SO. For instance, the name of the subform control could be something generic, like "Subform8", whereas the name of the form contained in the control (i.e. the name of the subform as it appears in the forms list of the Access window) might be "frmMySubform". If you open the property sheet of the subform control, under the "All" tab you will note that the first two fields are "Name" and "Source Object." Name is the name of the control; source object is the name of the form to which the control is bound. This concept is true of any bound control, and I almost always make it a point to give the control a different name from the object to which it is bound.

So, in my example, using the control and subform names above, with a textbox named "txtSomething" on the subform:

Me![blue]Subform8[/blue].[purple]Form[/purple]![blue]txtSomething[/blue]

...is the syntax to refer to the "txtSomething" control on the "Subform8" subform. Note that I used the name of the subform control ("Subform8"), not the name of the subform control's source object ("frmMySubform").

Then if I wished to refer to a property of an object on the subform, for instance, the Visible property of "txtSomething":

Me![blue]Subform8[/blue].[purple]Form[/purple]![blue]txtSomething[/blue].[purple]Visible[/purple] = False

Does that help explain it a little better?

Ken S.

 

[kupe]

Yes, it does, Ken S, and very much obliged to you. I've copied it and will save it in my #1 notebook.

Thanks very much for going to all that trouble. It is appreciated very much. Cheers