subForm on a subForm coding question

G

Graham Naylor

Hi,

I am used to having a subform on a form and in the code associated with the
subform referencing a control on the main form using
"Forms![Main].Control.value

But if I have a subForm on a subForm all on a main form. From code
associated with either subform I can reference a control of the main form
using the code above. But how do I reference a control on the 1st subForm
from code associated to the 2nd (lower level) subForm?

I hope that makes sense and thanks in advance for any help

Graham
 
G

Graham Naylor

Thanks, works perfectly

Graham

Beetle said:
Forms!MainForm!NameOfFirstSubformControl.Form!NameOfControl
--
_________

Sean Bailey


Graham Naylor said:
Hi,

I am used to having a subform on a form and in the code associated with
the
subform referencing a control on the main form using
"Forms![Main].Control.value

But if I have a subForm on a subForm all on a main form. From code
associated with either subform I can reference a control of the main form
using the code above. But how do I reference a control on the 1st subForm
from code associated to the 2nd (lower level) subForm?

I hope that makes sense and thanks in advance for any help

Graham
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
main form/subform 1
Referring to control in the active subform 0
set focus to control on subform 0
RecordsetClone on a subform 3
Filter Subform 1
DLookup in Continuous form 0
VBA code returns no records hwenKey ID is added 14

Top