Blank Text box during query calculation

[StefanScheidegger]

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

 

[JoanneM]

A work around for this may cause a little extra work
& the hourglass issue I'll check into
but first you blank while calculating

make the txt box with calc data hidden put an unbound txtbox on your form

after the requery of the data put
doevents - this ensures the last process is complete

then put
me.visibleTxtbox = hiddentxbox
me.repaint

that's answer 1 now I'll just go do a quick check for the hrglass prob

regards#

jo

ps replace visibletxtbox with the name of the actual box on your for and the same for the hiddentxtbox - these are explanatory names.

 

[StefanScheidegger]

Thanks very much.

This resolved my first problem.

Stefan