Subforms in Access 2000

[stellJess]

G’morning!

I need some help w/subforms. I have 3 forms A, B, C.
A is the main form w/subform B nested. Subform B has subform C nested w/a tab control.

The functionality in subforms B & C works fine without problems as a standalone --> Subform C sends data out to subform B. however, when these two forms are placed on subform A, the functionality does not work. I get error message #2450 that Access cannot find subform B referred to in a macro expression or visual basic code.

Can anyone out there please shed some light on my dilemma.

Any help you can give is appreciated.

stellJess

 

[930driver]

You're probably referring to form B by it's name. Once it's a subform it's no longer a 'form', it's a subform. You can refer to it explicitly by referring to form A's subform control something like this:

Forms!FormA!subFormB.Form.control

Alternatively in form C you can refer to Parent.control which will refer to form C's parent, in other words form B.

Hope that makes sense. "The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"

 

[stellJess]

930driver,

Thank you, that worked!!!