[AccessD] Forgotten Syntax

Steve Schapel miscellany at mvps.org
Tue Jul 3 12:03:56 CDT 2007


Arthur,

What does the "B" refer to in your example?  Do you mean you want the 
result in a control on a subform?

If the value form the popup form is going into a control on form A, then...
Forms!A!ResultPlace = Me.Result

If the value form the popup form is going into a control on subform B on 
form A, then...
Forms!A!B.Form!ResultPlace = Me.Result

Regards
Steve


Arthur Fuller wrote:
> I want to assign a value to a form that is guaranteed to be open. Scenario:
> OnEnter of a field on form A pops up a dialog that asks for a couple of
> values. Then I want to post the result to the field on form A and close the
> popup.
> 
> Something like:
> 
> Forms("A").form.B.ResultPlace = Me.Result
> 
> or something. I keep forgetting this syntax. This time I'll tatoo it.
> 
> A.



More information about the AccessD mailing list