I have a form (form A) that "shows" another form (form B). Form B collects
data that I want to be available to Form A when Form B is unloaded.

In addition I want to pass data from Form A to Form B when it is
instantiated. I assume I can set the value of hidden label when I create
form B, but this seems a little stupid.

Any advice on how to do this?

Declare a public variable in a standard code module, simplest way.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"fedude" <(E-Mail Removed)> wrote in message
news:6741FFB5-EFCA-4508-9D6E-(E-Mail Removed)...
>I have a form (form A) that "shows" another form (form B). Form B collects
> data that I want to be available to Form A when Form B is unloaded.
>
> In addition I want to pass data from Form A to Form B when it is
> instantiated. I assume I can set the value of hidden label when I create
> form B, but this seems a little stupid.
>
> Any advice on how to do this?

On Jun 3, 7:46*am, fedude <fed...@discussions.microsoft.com> wrote:
> I have a form (form A) that "shows" another form (form B). *Form B collects
> data that I want to be available to Form A when Form B is unloaded.
>
> In addition I want to pass data from Form A to Form B when it is
> instantiated. *I assume I can set the value of hidden label when I create
> form B, but this seems a little stupid. *
>
> Any advice on how to do this?

I agree with Bob. Declare Public variables in a standard module and
then set them as needed. For instance, if you want textbox1 on Form B
to be populated when it opens with the value from textbox2 on Form A,
you could use:

Standard module:
Public example As String

Button on Form A that opens form B
example = Me.textbox2

Initialize event of Form B
Me.textbox1.Text = example

HTH

Do I just creat another module anyhere in the spreadsheet or is there
someplace special I need to declare these variables?

"JW" wrote:

> On Jun 3, 7:46 am, fedude <fed...@discussions.microsoft.com> wrote:
> > I have a form (form A) that "shows" another form (form B). Form B collects
> > data that I want to be available to Form A when Form B is unloaded.
> >
> > In addition I want to pass data from Form A to Form B when it is
> > instantiated. I assume I can set the value of hidden label when I create
> > form B, but this seems a little stupid.
> >
> > Any advice on how to do this?
>
> I agree with Bob. Declare Public variables in a standard module and
> then set them as needed. For instance, if you want textbox1 on Form B
> to be populated when it opens with the value from textbox2 on Form A,
> you could use:
>
> Standard module:
> Public example As String
>
> Button on Form A that opens form B
> example = Me.textbox2
>
> Initialize event of Form B
> Me.textbox1.Text = example
>
> HTH
>

On Jun 3, 10:49*am, fedude <fed...@discussions.microsoft.com> wrote:
> Do I just creat another module anyhere in the spreadsheet or is there
> someplace special I need to declare these variables?
>
>
>
> "JW" wrote:
> > On Jun 3, 7:46 am, fedude <fed...@discussions.microsoft.com> wrote:
> > > I have a form (form A) that "shows" another form (form B). *Form B collects
> > > data that I want to be available to Form A when Form B is unloaded.
>
> > > In addition I want to pass data from Form A to Form B when it is
> > > instantiated. *I assume I can set the value of hidden label when I create
> > > form B, but this seems a little stupid. *
>
> > > Any advice on how to do this?
>
> > I agree with Bob. *Declare Public variables in a standard module and
> > then set them as needed. *For instance, if you want textbox1 on Form B
> > to be populated when it opens with the value from textbox2 on Form A,
> > you could use:
>
> > Standard module:
> > Public example As String
>
> > Button on Form A that opens form B
> > example = Me.textbox2
>
> > Initialize event of Form B
> > Me.textbox1.Text = example
>
> > HTH- Hide quoted text -
>
> - Show quoted text -

They just need to be declared at the top of a standard module. I
typically create a module for nothing but my public declerations.

Thank You.