| How to refer to controls (text field, label, etc.) on a sub form |
|
If you have ever tried to build an application in MS Access you probably came across the problem of referring to a control from a main form to its sub-form. Here is a very brief guide how should the reference look like.
A complete reference should be as follows: Forms![FormName]![SubFormName].Form![ControlName] FormName stands for the name of the main form. If you want to use a shorter version then you can use the internal reference. The reference will look like this: Me![SubFormName].Form![ControlName] It is referencing a sub-form from the opened form (“Me” ). |
