flicker on =count(*) on record form

[OTWarrior via AccessMonster.com]

I have a count of the total ammount of records currently being displayed on
the form, but if there is only 1 record, then the count form field flickers,
until you move the move over it.

this is a problem, as some of the other commands to open form will not load
until this "event" is completed.

How do I complete the "event"

the code behind the form field (held in the footer of the subform) is simply :


=count(*)

 

[Allen Browne]

To get a solution, you will need to identify what is causing the endless
loop.

Does anything on this form use Conditional Formatting?
If so, try removing it.

Is there any code in the form's Current event?
If so, try commenting it out.

Anything in the form's Open, Load, or Activate events?

Anything else that could be contributing? Subform?

 

[OTWarrior via AccessMonster.com]

ah, thanks for that, managed to solve it.

I have an option group for the subform, and when you choose an option, it
requeries the subform.

I now have a working database again