Referring to a Subform's ControlSource

  • Thread starter Thread starter L.A. Lawyer
  • Start date Start date
L

L.A. Lawyer

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

What is the code?

Thanks.
 
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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing ControlSource property on a subform 3
referring to Subform Total in main form 1
Need subform total on main form ? 1
subform total to mainform 2
Using VBA to define the ControlSource property of an unbound field 2
Reference to calc field on sister subform? 1
Name Control in a Subform 1
calulated field on main after filtering subform 1

Back
Top