Returning Value from a Form

  • Thread starter Thread starter JohnV
  • Start date Start date
J

JohnV

Is it possible to return a value from a form when it is
called from a function or sub. I seem to recall seeing
something on topic. Any help would be appreciated.

Thanks,
JohnV
 
Can you clarify what you mean by "return a value from a form when it [the
form?] is called from a function or sub"?

If you mean, can you "read" the value of a control on a form from a function
or sub, that answer is yes, so long as the form is open. You get the value
by a code step similar to this:

ValueFromForm = Forms!FormName!ControlName.Value

If you mean something else, please clarify. Thanks.
 
Back
Top