Re: Best way to pass data between forms?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Bob Phillips" <bob.NGs@xxxxxxxxxxxxx>
Date: Tue, 3 Jun 2008 13:33:08 +0100

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" <fedude@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6741FFB5-EFCA-4508-9D6E-13DBD2024207@xxxxxxxxxxxxxxxx

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?

References:
- Best way to pass data between forms?
  - From: fedude

Prev by Date: Re: Checking to see of a folder exists
Next by Date: RE: For Loop with headers
Previous by thread: Best way to pass data between forms?
Next by thread: Re: Best way to pass data between forms?
Index(es):
- Date
- Thread

Relevant Pages

Re: Date query
... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... What is the simplest way to check 5 different dates to see if they lie ... I need to check around 200 voyages at a time. ...
(microsoft.public.excel.worksheet.functions)
Re: Selection.Cells vs Range reference - strange behaviour (using
... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... parentheses to indicate the parameters to be passed. ... I have a series of subs for formatting text along the lines of ...
(microsoft.public.excel.programming)
Re: Help with SUMIF
... It worked because any non-zero value is TRUE, so for the odd columns *1 ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... "Bob Phillips" wrote: ...
(microsoft.public.excel.worksheet.functions)
Re: Formula to get sum from one 31 sheets to a summary sheet.
... "Bob Phillips" wrote: ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... This is brand new to me, please forgive me if my related communication is ...
(microsoft.public.excel.misc)
Re: visual basic error
... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... ' AvgRounds Macro ... Dim total_plays As Byte, used_plays As Byte ...
(microsoft.public.excel)