Startup/Setup Form and Carry on selected record afterwards

[miltiadis21]

Hello I want to have a Startup form shown only once into the user In order to Setup some parameters for the program at the first time. In my case the user will choose the country that he/she belongs.
Then the form will close and go to the main form. Then the user on the main form will select the corresponding region that was selected in the beginning from the cboRegion. The program logic would be one country selection per database
For example:
1. Startup Form
1.1 Choose from combo box a Country
1.2 Store Country in database
1.3 Open main Form for data editing and user input
2 .Main Form
2.1 Region from corresponding Country will only show
2.2 Select Region
2.3 On Next Record Rule 2.1 will imply
I have attached a database will two combo boxes synchronized a CboCountry and a CboRegion
My main idea is to have only cboRegion Synchronized with the country in the main form once it is selected at the Startup/Setup Form
Thanks!

 

[Dennisk]

just store the combo box values in global variable(s) then you may pick up the values on other forms. These values will stay in memory until you close the application.

Another way is to hold those values in a local table

 

[miltiadis21]

i can understand what you are saying i think.And what about the Startup setup form how i am going to appear it only once ?
Thanks for your reply

 

[G37Sam]

what i would do is create a table which will contain these global variables. one of these variables would be a boolean variable where you will store "first time". Then simply write a code to set the value of first time to false after that main form is loaded for the first time. Everytime your DB starts, check whether first time is true or false and based on that display the desired form