Text box not showing text

Hello,

I have a series of text boxes on a form with the expressions like this:

=DCount("[UID]","[qTesting]","[Test Subject]='Numeracy' And [Test Level]='Entry Level' and [Passed]=Yes")

So the role of the text box is to, check the query for Numeracy tests at Entry Level that have been passed and return the total (count of UID field)

However the problem is, the form stalls on calculating the fields. The status bar in the bottom left says "Calculating..." but it does not do anything and the fields remain blank. Now if I switch windows, (for example alt-tab into explorer) and then go back to access it will finish calculating and show the results (the results are as should be) however if left by itself it didn't finish calculating. I tried waiting for about 2 mins and it never finished...

I presume this is a bug but is there any solution?

Many thanks for any responses.

Instead of writing code in control source of text box

use some vba event to populate text box (such as form open event) like
and so on

khawar said:

Instead of writing code in control source of text box

use some vba event to populate text box (such as form open event) like

Code:

me.textbox1=DCount("[UID]","[qTesting]","[Test Subject]='Numeracy' And [Test Level]='Entry Level' and [Passed]=Yes")

me.textbox2= .......

and so on

Click to expand...

That worked a treat! Thank you very much. (a lot faster than using the control source also even when it did work