I have a main form with two subforms (say, subformA and subformB). The main form only served as a container. There is a combo box in the subformB.
I put the following statement at subformA's on current event:
And I got the following error message:
run-time error '2455':
You entered an expression that has an invalid reference to the property Form/Report.
The property may not exist or may not apply to the object you specified.
What's wrong with the statement? It seems I can't access the other subform's controls from/within another subform. I put a command button on the main form and put the following statement on the click event,and it worked:
devtha: Nice try, but the | character is changed by access according to the problem at hand. If a reference has been made to the form property and this is not valid then | is changed to form -> 'Invalid
Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted. Others take a little more time and effort and often providing a sample database is very helpf…
The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…