Refresh Listbox on timer issues

[hudaz]

Hi Everyone,

I'm having some issues with my list boxes at the minute and i wondered if anyone could help.

I have a form that refreshes every second, i also have a list box on that form that requeries on the timer (every second)

this works fine most of the time but users (who are using the free version of access which is front end only) are reporting crashes when they use the form and i get a runtime error which states i need to "save current field before you can run the requery action"

My code is basically listbox.requery is there a alternative way of doing this so that i no longer get this error ?

Thanks!

Andy

 

[Minty]

If you are running the two timer events separately they are probably clashing. This begs a couple of questions;
A) why update it every second ? This sounds like overkill in both process and requirement?
b) why not update them both on the same timer event ?

 

[jdraw]

How about telling us in simple terms What you are trying to accomplish with your set up? Tell us about your application.
There may be options.

 

[arnelgp]

then don't use timer.
requery only the listbox when it gets focused. (OnGetFocus).