dlookup in sub subform

[deb]

I have a text box(TLPrefix) in my sub subform(fTLNo)
I need the text box to be the same data as the textbox(TLNoPrefix) on the
main form(fProject).

all IDs are numeric
Main form Project - table tProject - ProjectID
Sub form fDeliverable - table tDeliverable - DelivID and ProjectID
Sub Subform fTLNo - table tTLNo - TLNoID and DelivID

how can I make my text box on the sub subform show the same as a text box on
the main form?

 

[Scott Lichtenberg]

There are a couple of ways you can attack this. I've never done this in a
sub-subform, but in theory, the methodology should be pretty similar to what
you would do if you just had a two level (parent/child) form.

The normal method would be to refer to a field on a parent form as follows:

Me!MyField = Parent!MyField

I don't know how you would refer back two levels. You can try referencing
the top level form directly:

Me!MyField = Forms!frmTopLevel!MyField

You can use this approach in the control source property of the field on
your sub-subform.

=[Forms!frmTopLevel!MyField]



Hope this helps

 

[Larry Daugherty]

Look in Access Help for Form/SubForm Referencing or find more
information at the Access Web: www.mvps.org/access

HTH