refresh every so often

mattbland

Isnt really listening
Local time
Today, 10:03
Joined
Aug 8, 2002
Messages
33
couple of questions:

ive got a db with two forms both linked to the same table - edits allowed, and no-edits.

1) if the edits form is updated, will the update be shown in the no-edits form?

2) is it possible to insert a refresh that automatically refreshes every 5 or 10 mins (hopefully solving the above prob)

Cheers
 
Use the Timer event, set the interval to an appropriate period
Me.Refresh
 
Access automatically refreshes open recordsets to obtain changed data. To obtain NEW rows, you need to REQUERY the recordset.

You can have a timer that requeries behind the scenes or you can force a requery after every update.
 

Users who are viewing this thread

Back
Top Bottom