Referring to a Subform's ControlSource

L

L.A. Lawyer

I want to refer to a subform's ControlSource (Access 2000).

What is the code?

Thanks.
 
K

Ken Snell \(MVP\)

A subform does not have a ControlSource property. Are you wanting the
SourceObject property (which is the name of the form that is being used as
the subform)?

Assuming yes, this reference can be used in the module for the main form:

Me.NameOfSubformControlOnMainForm.SourceObject
 
B

Beetle

A *subform control* has a Source Object, which would be;

Me![NameOfSubformControl].SourceObject

-or-

A *subform* has a Record Source, which would be;

Me![NameOfSubformControl].Form.RecordSource

but neither one has a Control Source
 
M

Marshall Barton

L.A. Lawyer said:
I want to refer to a subform's ControlSource (Access 2000).

What is the code?
Click to expand...


Neither a subform control nor a form object displayed in a
subform control have a control source property. If you
meant the record source property, then the syntax would be:
Me.[subform control].Form.RecordSource
 
Top