I have a query that has criteria based upon the users input for the field Invoice Number on the invoice entry form. Everything works perfectly when done from the invoice entry form directly. When accessed through the main navigation form (upon which the invoice entry form is a tab) I get the popup dialog asking for the invoice number because it doesn't understand the reference to it which was previously Forms!frmInvoiceEntry.[InvoiceNumber]. I quickly realized that error was because I was accessing the form through the navigation form and needed to change the reference. I have changed it to the reference below but I still get the dialog.
My assumption is that this is because I am only referencing the form and not pointing to the appropriate tab but I don't know how to do that correctly. I need the appropriate syntax for referencing the control [InvoiceNumber] on the form [frmInvoiceEntry] which is one "subtab" of my Data Entry tab on my access navigation form [frmPropertyNavigation].