Solved Referencing a sub sub control

[ClaraBarton]

All of these controls work except for the Authors (line 20) and Subjects Line 70). These both throw an error 2455.

• I've removed the bangs and replaced with dots.
• I've made sure the names are not the same as the record source names.
• I've made sure the headers on the Authors and Subject subcontrols are not visible.

Is there something I'm missing?

      Dim ctlAuthor As control
      Dim ctlIllustrator As control
      Dim ctlPublisher As control
      Dim ctlSeries As control
      Dim ctlStatus As control
      Dim ctlSubject As control
'20    Set ctlAuthor = Me!BookDetail.Form!Authors.Form!btnClear
30    Set ctlIllustrator = Me!BookDetail.Form!btnClearIllustrator
40    Set ctlPublisher = Me!BookDetail.Form!btnClearPublisher
50    Set ctlSeries = Me!BookDetail.Form!btnClearSeries
60    Set ctlStatus = Me!BookDetail.Form!btnClearStatus
70    Set ctlSubject = Me!BookDetail.Form!Subjects.Form!btnClear

 

[MajP]

Most likely is the name of the sub subform control. Obviously BookDetail is correct. My guess the sub-subforms are not called Authors, and not called Subjects. Click on the outside and check.

 

[MajP]

I looked at an old version and they are called fSubAuthors and SubSubjects.

 

[ClaraBarton]

I looked at an old version and they are called fSubAuthors and SubSubjects.

please... this form has traveled many miles from the old one! I renamed them. They are right. Actually, I renamed them to Authors and Subjects to change from the recordsource. Before I renamed them it was the same error.

 

[Gasman]

Forms: Refer to Form and Subform properties and controls

 

[ClaraBarton]

Forms: Refer to Form and Subform properties and controls

I refer to that religiously!

 

[MajP]

Does not look like a problem with the referencing, if the names are correct. That error does suggest the subform control is correct, but the source object is not loaded. (Invalide reference to form property)
Where is the run? This can be a timing thing. When this code is run can you verify that the sub subforms are loaded. If there are no linked records at the time then the sub-subform may not be loaded.

Try this to help error check. It is a little clearer.

Dim   btnAuthor As CommandButton
Dim   btnIllustrator As CommandButton
Dim   btnPublisher As CommandButton
Dim   btnSeries As CommandButton
Dim   btnStatus As CommandButton
Dim   btnSubject As CommandButton
Dim   sfrmDetail as access.form
dim   ssFrmAuthors as access.form
dim   ssFrmSubjects as access.form

set sfrmDetail = me.bookDetail.form
set ssFrmAuthors = sFrmDetail.Authors.form
set ssFrmSubjects = sFrmDetail.Subjects.Form

set btnIllustrator = sFrmDetail.btnClearIllustrator
Set btnPublisher = sFrmDetail.btnClearPublisher
Set btnSeries = sFrmDetail.btnClearSeries
Set btnStatus = sFrmDetail.BtnClearStatus

Set btnAuthor = ssFrmAuthors.btnClear
Set btnSubject = ssFrmSubjects.btnClear

If this is a case where you are assigning the control before the form is loaded then I would likely have to see the db to recommend a solution. Likely you will have to assign it in a later event.

 

[MajP]

Even better would be to dimension your subforms using the real form name class (as shown in the object browser)

Dim   sfrmDetail as Form_FrmDetail
dim   ssFrmAuthors as Form_FrmAuthors
dim   ssFrmSubjects as Form_FrmSubjects

where the real name of the form is proceeded by Form
Form_YourFormName

This will ensure intellisense works for all objects referenced.

 

[ClaraBarton]

Intellisence gave me Authors and Form

 

[MajP]

Again that is one or two things. Either you are wrong and Authors is not a control (subform) name of lstSubDetail or the subform control does not have a form loaded at the time you try to set it. Triple check the name of the subform control (not the name of the subform).

 

[MajP]

To further error check you could do this

....
dim   scAuthors as access.subform

set sfrmDetail = me.bookDetail.form
set scAuthors = sfrmDetail.Authors
set ssFrmAuthors = scAuthors.form

if scAuthors fails then you do not have a subform control named authors
if
ssFrmAuthors fails then the form is not loaded.

 

[ClaraBarton]

So the form isn't loaded?

Where do I go from here?

 

[ClaraBarton]

So the form isn't loaded?
View attachment 107156
Where do I go from here?

So... The detail form isn't filled until a book is selected in Books. So you're right, it isn't there. I'm using the option number on the form. Does that mean this code should be located on the detail form? Well, duh. of course. I'll go back to the drawing board... Thank you so much for your help.

 

[MajP]

So that tells me that your subform control is called authors and you can reference it. You cannot get a reference to the form property. Unless I am missing something your sub form lstSubAuthors is not loaded at this time. So you have a subform control, but nothing is in it when you call it. I think this can happen when the subform is set to allow additions to false and no records are returned.