Sub Form Update?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robert B - 05 Aug 2005 09:03 GMT

I have a multiple user FE/BE database.
Depending department determins which FE they have.

One Departments FE has a main page with there own buttons ECT and, a SUBform
linked to a table displaying missing items that another department has
entered into the database.

Most departments leave the FE open as the day goes on and simply select which
task they wish to perform from the relevant FE. The problem is that my
SUBform only updates as the page is loaded.

is there any way i can get the page to self reload/ update say every hour?

Cheers for any advice

Reply to this Message

Ron Weiner - 05 Aug 2005 12:15 GMT

Robert

You could use the Timer on the Sub Form to trigger a requery every n
minutes. If you wanted to refresh the form every 10 minutes you'd set the
Forms Timer Interval Property to 600000 and in the Forms Timer even you
would requery the form. Code might look like this:

Private Sub Form_Timer()
Me.Requery
End Sub

Ron W
www.WorksRite.com

> I have a multiple user FE/BE database.
> Depending department determins which FE they have.
[quoted text clipped - 10 lines]
>
> Cheers for any advice

Reply to this Message