sub form basics

[SueBK]

I'm a little hazy about how subforms work. My specific question in this instance is about a form I haven't designed, but which I'm trying to add some code to.

I have a main form: frmGroup
The subform is called: subfRolesSubform

But when I open "frmGroup" in design view and click the sub-form it's called "tblRoles Suborm".

Why would this be? It's confusing me when I try to write my code to have the subform called something different.

 

[pbaldy]

There are two items here. One is a subform control on the mainform, the second is the form being put into that control. It sounds like they have different names in this instance. Check the properties of the subform control on the mainform, where you should see both.

 

[SueBK]

I feel like a right proper dummy I opened a 'dead' database and created a form with a subform (so scared I'll "break" the real database), and realised what was going on when it asked me to name the sub-form control.

I've now re-named the subform in the real database to better reflect where it's coming from and what it actually is.

Thanks!

 

[pbaldy]

Happy to help. No need to feel like a dummy. It is definitely confusing until you realize what's going on, because it isn't readily apparent.