Refresh Screen?

[marie515]

Hi all,

On my main menu, I show how many "open" records are in the database. This way, the user can click on the "open records" button and go directly to work on the cases that are still open.

Question: Let say someone goes into the main menu and then clicks on the open case list and works the case. If someone else is in the main menu at the time that the database showed open cases, then it never changes unless the user gets out of the main menu and goes back in. In other words, it is not "refreshing" the data automatically to show if cases are worked unless the user goes out and back into the screen.

Is there a way to tell the form to "refresh" every 3 minutes or something like that?

Thanks!

 

[Loktar]

I know that there is a way to set a timer event in forms, but there might be a way to refresh the form every time it recordsource is updated.

The code you will want to use is

Me.Requery
or
Me.Refresh

Which one you use depends on how you've built your forms. The easiest way is to try both and see which works/works fastest.

 

[marie515]

Thanks Loktar!

Which event do you think I should load this onto..."before update" or "after update"?

 

[scottian]

you can either set the timer event or use oncurrent.
timer will referesh every set time. oncurrent will refresh each time the focus changes to a different field

Be ALERT - Your country needs Lerts