Share via

Subform control name

Anonymous
2018-06-23T10:54:35+00:00

Hi. I have a question. A user told me:

"Normally, when we insert the form directly, Access gives the control the same name as the subform. But there are times when names differ. If in the design view, you click on the subform, you will see the control properties of the subform and its name. Check that the name is the same as the subform, because that is the name we should use when we are going to look for the subform."

I'm trying to figure out the control name of the subform. Could anyone confirm that  this is the one looked for? Thanks

(Sorry it's in spanish). Título is "title". 

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

2 answers

Sort by: Most helpful
  1. Anonymous
    2018-06-23T18:01:10+00:00

    I think the Título property is the Caption property in English, not the Name property, which, as Scott points out, is on the Otras tab of the property sheet.

    As regards the advice you received, a subform control can be given the same name as its source form object, but whether it should or not is another matter.  There is a case for naming objects unambiguously to avoid any confusion as to what is being referenced. I would normally use different prefixes for the subform control and its source form object, e.g. frmSubOrderDetails for the source form object and sfcOrderDetails for the subform control.

    I have to confess that I do sometimes forget, and leave the subform control named with its source form name.  This sort of thing seems to happen more frequently as my 70th year recedes further into the past!

    Was this answer helpful?

    0 comments No comments
  2. ScottGem 68,830 Reputation points Volunteer Moderator
    2018-06-23T11:08:24+00:00

    Formulario

    the drop down at the top of the Properties dialog lists the control names. Also the Other (Otras) tab shows the Name property of the control.

    Was this answer helpful?

    0 comments No comments