refresh every so often

[mattbland]

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

 

[Rich]

Use the Timer event, set the interval to an appropriate period
Me.Refresh

 

[Pat Hartman]

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.