Ready for a challange? Complex Text Box Issue

[StefanSch]

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

 

[Rich]

Why are you using a query for complex calculations?

 

[StefanSch]

I do it in a query, because these calculations cannot be done on the form directly.

Thank you for your help.

Stefan

 

[Mile-O]

How complicated?

You could calculate them in a function.

 

[StefanSch]

If it were possible, I would not be able to do that due to a lack of profound programming knowledge/experience.

Therefore, I guess it is easier to make sure by code that:

- the old value in the text box does only appear when the new value is calculated.
- "Remove" the hourglass which appears
(cannot be done with DoCmd.Hourglass (0)
or DoCmd.Hourglass False)

Thank you for your help.

Stefan

 

[Rich]

I asked because I suspect your using a tabular form with several records and the query has to re-calculate the entire record set not just a single value, give us some more details.

 

[StefanSch]

Hello Rich

you are completely right. I am using a tabular form with several records and the query has to re-calculate the entire record set.

Is this the reason that the text box remains blank for a second or so and that I am unable to turn off the hourglass?

Thanks for your support, Rich.

Stefan