Nested MS Access subforms associated with the main (parent) form

Question

I am developing an MS Access 2007 application that requires the use of subforms with a rather complex user interface. I know how to create a parent form and bind to a subform so that it displays the data related to the record of the parent form, but my question is this:

If I have several nested subforms (say, 3 or 4 levels), can I somehow relate the subformation sitting on the 4th level with the record of the parent form on the 1st level? What I mean by nested subforms has a form inserted inside a form, inserted in another form, etc.

The subform I want to associate with the parent form currently uses the query as the source object, and the reason for using the subform is purely for the aesthetics of the user interface.

Is there an easy way to do this? Or perhaps using VBA?

Answer 1

One thing that many people don’t understand is that LinkChild / LinkMaster fields can really be any valid expression. Thus, you can have subForm1 LinkChild / LinkMaster properties:

  LinkMaster  CustomerID
  LinkChild   CustomerID

Then subForm2 may have the following:

  LinkMaster  subForm1.Form!InvoiceID
  LinkChild   InvoiceID

... etc. I can’t imagine that it will be much deeper, but it is possible.

, , . (-, , , , - ). .

Answer 2

( - ), , "Sunken" Special?