Queries - Access control in 2nd level subform using tab control

Hi all,

I tried a few google hits in regards to this but it doesn't seem to be working. I have 3 forms (frminstution -> invoice -> frminvoicelinedetail (this subform is on a tab control called pgShipping)).

I am trying to reference an object (called OrderLink) on the InvoiceLineDetail in a query.

These were attempts at trying to go about it. All I get is a parameter box, which there should be none (the forum is open so it isn't that)







Am I setting it up wrong, or am I missing something to do with the Tab Control?

Btw this was mySource

Thanks,

Depends on where you are referencing from.

In VBA code use (invoice is name of subform container control?):
[Forms_frminstitution].[invoice].[Forms]![Orderlink] or
[Forms_frminstitution].[invoice]![Orderlink] or
[Forms_frminstitution]![Orderlink]

In a textbox control:
From a subform referring to mainform control
[Forms]![mainformname]![tbxOrderlink]
From a mainform referring to subform control
[subformcontainername]![tbxOrderlink]

References to objects in subforms and/or tabs can be very difficult. This is where the Build wizard is really helpful. Instead of flailing around with the syntax, I strongly recommend just clicking on the Build icon (the one that looks like a magic wand with fairy dust sprinkles--or whatever that's supposed to be). You will save yourself a lot of time and trouble.