AboutScottgem Expertise I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
Experience I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.
Organizations Author of Microsoft Office Access 2007 VBA Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing
However, I cannot find a way to have the query resolve the reference when opening the form as a subform in the main. Complicating matters is that the subform is residing on a tab control: InventorySubFormTab
I have tried updating the value in the query to the following without luck:
Do I need further qualification of the subform field when it resides on a tab control (I've tried to add this as well with no luck)?
Thank you in advance for any help you can provide.
Answer First, you don't have fields on a form, you have controls that may or may not be bound to a field in a table. This is a subtle but important distinction.
The correct syntax for referencing a value in a control on a subform is:
Forms!formname!subformname.Form.controlname
A Tab control doesn't impact on that.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: MS Office Access 2007 VBA
