I need a best practice answer:
Example Form1 with data bound controls and a Public Variable Form1Var
Form2 with data bound controls and a Public Variable Form2Var
DataTables are related Form2 Data is related to Form1 Data in a one-to-many
What I am trying to accomplish.
When editing Form1 data there is a button to open Form2 if new data needs to be added. on closing Form2 I would like Form1 to remain at the state it was in before opening Form2. If I Change Visibility of Form1 when Form2 is opened upon Retun to Form1 Data is reloaded, if I minimise Form1 when Form2 is opened upon return to Form1 Public variables are reset to defaults. Any Help would be appreciated.
I have many Forms with many controls and buttons to do Lookups or additional add to related tables.
Thanks
Example Form1 with data bound controls and a Public Variable Form1Var
Form2 with data bound controls and a Public Variable Form2Var
DataTables are related Form2 Data is related to Form1 Data in a one-to-many
What I am trying to accomplish.
When editing Form1 data there is a button to open Form2 if new data needs to be added. on closing Form2 I would like Form1 to remain at the state it was in before opening Form2. If I Change Visibility of Form1 when Form2 is opened upon Retun to Form1 Data is reloaded, if I minimise Form1 when Form2 is opened upon return to Form1 Public variables are reset to defaults. Any Help would be appreciated.
I have many Forms with many controls and buttons to do Lookups or additional add to related tables.
Thanks