Best way to pass data between forms?
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? |
Best way to pass data between forms?
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" wrote in message ... 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? |
Best way to pass data between forms?
On Jun 3, 7:46*am, fedude 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 |
Best way to pass data between forms?
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 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 |
Best way to pass data between forms?
On Jun 3, 10:49*am, fedude 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 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. |
Best way to pass data between forms?
Thank You.
|
All times are GMT +1. The time now is 10:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com