Hi
I have a form which also includes a text box with recordsource Query X.
The Query X performs quite complicated calculations. So, after every input by the user, the hourglass appears and the "old value" of the text box disappears until MS Access has finished the calculations in the query. The form shows then the new updated value in the test box.
How can I achieve the following:
- The text box should show the "old value" until the "new value" is calculated. The text box should not be blank during the query calculations.
- If you have any ideas to the hourglass: I would like that MS Access does not show the hourglass. It shows it automatically due to some internal process I guess (query calculations). I posted this hourglass question before without much success.
Please note that "DoCmd.Hourglass False" and "DoCmd.Hourglass (0)" do not solve this problem.
Thank you so much for your help. I appreciate it.
regards,
Stefan
I have a form which also includes a text box with recordsource Query X.
The Query X performs quite complicated calculations. So, after every input by the user, the hourglass appears and the "old value" of the text box disappears until MS Access has finished the calculations in the query. The form shows then the new updated value in the test box.
How can I achieve the following:
- The text box should show the "old value" until the "new value" is calculated. The text box should not be blank during the query calculations.
- If you have any ideas to the hourglass: I would like that MS Access does not show the hourglass. It shows it automatically due to some internal process I guess (query calculations). I posted this hourglass question before without much success.
Please note that "DoCmd.Hourglass False" and "DoCmd.Hourglass (0)" do not solve this problem.
Thank you so much for your help. I appreciate it.
regards,
Stefan
