jonathanchye
Registered User.
- Local time
- Today, 23:05
- Joined
- Mar 8, 2011
- Messages
- 448
Hi all,
I am currently developing in MS Access 2010. I have used the Tab Control feature in my form which I find very helpful.
My main form contains several comboboxes which the users filled in. Users then click on the tabs to display calculated values based on the values they've entered on the main form.
I've added some code so only relevant calculations run based on the tabs selected by the user. However, I think I would need to further improve performance. I am thinking of running another check to see if any of the properties on the main form is updated - If not then do not run any calculations.
The "Dirty" event seems useful but according to the KB this also triggers if users move between tabs. So in my case the calculations will still fire even if nothing is changed on the main form.
I am wondering if anyone could suggest something which could work in my case? I would dread having to write a code to loop through all the controls on the main page as I have plenty of them...
I am currently developing in MS Access 2010. I have used the Tab Control feature in my form which I find very helpful.
My main form contains several comboboxes which the users filled in. Users then click on the tabs to display calculated values based on the values they've entered on the main form.
I've added some code so only relevant calculations run based on the tabs selected by the user. However, I think I would need to further improve performance. I am thinking of running another check to see if any of the properties on the main form is updated - If not then do not run any calculations.
The "Dirty" event seems useful but according to the KB this also triggers if users move between tabs. So in my case the calculations will still fire even if nothing is changed on the main form.
I am wondering if anyone could suggest something which could work in my case? I would dread having to write a code to loop through all the controls on the main page as I have plenty of them...
