Problems referencing control on subform after changing source object of subform

[JFHBIFF]

Greetings everybody,

I am using an afterupdate event on my main form that changes the source object of my subform. This works fine.

If a control on that subform = true, I want to change the source object again. This is where my code fails. I get an error message stating it can't find that field. My code below.

Private Sub strIns_AfterUpdate()
Me.tblDefCatDump_subform1.Requery
Me.Command45.Visible = True
Me.Command44.Visible = True
Me.Command47.Visible = True
Me.tblDefCatDump_subform1.Visible = True
Me.Label126.Visible = True
Me.Label127.Visible = True
Me.[tblDefCatDump subform1].SourceObject = "frmInsCont1"

If Forms!frmSCOrd![tblDefCatDump subform1].Form!ysnPrefix = True Then '(Problem here)

Me.[tblDefCatDump subform1].SourceObject = "frmPrefix1"

End If

End Sub

Thanks for your help.

John

 

[RuralGuy]

So is the name of the SubFormControl [tblDefCatDump subform1] or [tblDefCatDump_subform1]?

 

[JFHBIFF]

Thanks for offering to help RuralGuy. Somebody helped me via PM. Below is the code that worked.

Forms!frmSCOrd![tblDefCatDump subform1].Controls("ynsPrefix")

Have a great evening!

 

[RuralGuy]

In which case
Forms!frmSCOrd![tblDefCatDump subform1].Form!ysnPrefix = True
...should have worked as well. Glad you got it sorted.