Cant get query parameter off form in a tabbed layout

[tagteam]

I am trying to use a field value from a form as a query parameter. The form is a subform in a tabbed navigation.



I am trying
[Forms]![frmAssignInvoiceShell]![frmAssignInvoice].[Form]![InvoiceNumber]

however, this is not working. Is there anything i need to specify that relates to the tab interface?

[rpeare]

Which is your main form name and which is your subform name?

What you have should work is frmAssignInvoiceShell is the main form and frmAssignInvoice is the subform
the INVOICENUMBER field must be a valid field on the subform as well

I tested it and it works both in terms of pulling the correct value and using it as a criteria in a query.

[CJ_London]

and frmAssignInvoice is the subform

to be more precise - the name of the subform control (often the same but not always)

[tagteam]

Yes the main form is frmAssignInvoiceShell and the sub form is frmAssignInvoice. I have also double checked that the subform control, which is a text box, is named InvoiceNumber. I also make sure to test the query when the parent and sub form are open and I am on that current tab. Is there any way to test to see if it is actually seeing that form at all of the tab control is causing some kind of problem?

[rpeare]

you can create a query based on any table (pick a short one just for example purposes)

then put in a field like:

canyouseeme: [forms]![formname]![fieldname]

it will spit back the value that's in the field, you can do this for your subform field (with the proper syntax) to see if it's spitting the information back correctly.

I suspect you just have something misspelled.

[CJ_London]

or - since the OP appears to have misunderstood my post, perhaps the subform control (i.e. the control which has the subform in it) is spelt differently.

Also, have you tried using the expression builder to navigate to the required control?

[John_G]

Just to clarify -

In your expression [Forms]![frmAssignInvoiceShell]![frmAssignInvoice].[Form]![InvoiceNumber]

the name in red must be the name of the form control containing the subform, not the name of the subform itself. (See Ajax's post #3)