Requery refreshing listbox twice ?

[David]

I have a Listbox.Requery statement in an OnActivate event
that appears to be refreshing the listbox twice.

If I remove this one statement, the listbox is not
refreshed, if I resinsert it, I get the 'blip' like its
being refreshed twice.
Any ideas?
Should I be using Docmd.Requery instead of
Listbox.Requery ?

 

[Dave Cousineau]

i guess breaking into OnActivate is a little tricky, since
when you break into the code, the window loses the focus

i would imagine the only way its actually being requeried
twice is if OnActivate is being called twice, which is
possible

you might try using a boolean variable that is set to true
OnDeactivate, and set to False OnActivate, and then only
Requery if MyVal = True
that wouldnt work though if there is a Deactivate event in
between the two Activate events, if there even is two of
them

just a thought...

i don't really know what you mean by a 'blip'