pass parameter to subform

[Guest]

Hello all:
I have an unbound MS Access form and subform. How do I pass the ClientID
value to the subform?

I've got it working except for passing in the variables from the parent
form. I declared a public variable mlngClientID in the parent form and it has
a value. I hoped that by declaring public, it would pass to the subform.
Apparently not. I get a syntax error stating mlngClientID is unknown in the
subform. Any help?

Thanks so much.

 

[Andi Mayer]

Hello all:
I have an unbound MS Access form and subform. How do I pass the ClientID
value to the subform?

I've got it working except for passing in the variables from the parent
form. I declared a public variable mlngClientID in the parent form and it has
a value. I hoped that by declaring public, it would pass to the subform.
Apparently not. I get a syntax error stating mlngClientID is unknown in the
subform. Any help?

You are on the right track

this variable is public, but only in the contex of the form

use (if on the real subform) me.parent.mlngClientID

or (from somewhere)

Forms("MyForm").mlngClientID