Difference between Form and Forms

[XelaIrodavlas]

Hi all,

I have a quick question but it's basically impossible to google an answer!

You know when you want to point at a control, you typically write =forms!myform!mycontrol...

But I've always been curious; when you start to write, Access suggests what you might be looking for, and right off the bat it offers 'forms' or 'form'. To date I have never used the latter and don't understand what it's there for.

Would it make a difference if i wrote =form!myform!mycontrol? Dropping the 's'

Any clues?

Edit: I just realised this was the worst place to put this question, as it doesn't actually show 'form' in a query! however if referring in a macro or from one form to another it does show up

Thanks all,

 

[Brianwarnock]

http://www.btabdevelopment.com/ts/ewtrhtrts

Form is used when you start referring to subform info but I suspect there may be more to it than that, it's been awhile.

Brian

 

[Frothingslosh]

Here's the reference I always give people who need to know how to refer to forms, subforms, controls, and the like: http://access.mvps.org/access/forms/frm0031.htm

You have to start out with either 'Me' or 'Forms!Formname' when referring to a form or any control/subcontrol/subform. 'Forms' itself is a collection containing all currently open forms.

 

[XelaIrodavlas]

To retrospectively answer my own question, and for anyone else searching form vs forms

Forms refers to the collection, forms!myform etc
Form is a property relating specifically to a subform , forms!myform!mySub.form.property

see link https://msdn.microsoft.com/en-us/library/office/ff837017.aspx