pass parameter to subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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?
Click to expand...
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
 
Back
Top