This statement (Me.Parent.OpenID) is not getting me the value of OpenID in the parent.
What's missing?
Thanks,
Bill
This statement (Me.Parent.OpenID) is not getting me the value of OpenID in the parent.
What's missing?
Thanks,
Bill
are you trying to reference the field OPENID on the MAIN form from inside a subform? Or are you trying to reference a field on your main form in a query/report or other object?
are you trying to reference the field OPENID on the MAIN form from inside a subform?
Yes. Sorry, I didn't post the question very well. The sub-form code is responding to an event wherein it needs to know the current value of OpenID that is Dim'd and set in the parent.
Bill
if the variable exists only inside vb code you would have to pass that variable to a field on your subform (you can set the visible property of that field to false if you don't want it to show) without seeing your form I'd be guessing but if you are referencing a FIELD from your subform it'd be something like
forms!frmMainFormName!FieldName. If you're generating an OPENID from code you'd have to populate a field to reference it (or build a global function)
While waiting for a better solution, I used a global variable in order to have access and advance my development. With your suggestion, I abandoned the global approach and added an invisible text-box to the main (parent) form and accessed the value using forms!frmRosterDetail!tbOpenID.
Thanks,
Bill