Form Refresh in Network Environment

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

How can I make the form refresh to show all records without closing it?
The database has 2 front ends and of course 1 back end which is located on
the server.
If 1 user enters a new record, it does not show up right away on the other
users form until they close an re-open.
Is there a setting in acces to adjust for this? I can do a F9, but this does
not work!

Thanks,

Dave
 
First, the refresh method only refreshes the records in the current
recordset. It doesn't check for records that have been added which might now
meet the criteria of the current recordset. The Requery method does this -
it actually reissues the query and obtains a new recordset for the form.

The easiest way to do this is to create a timer event for the form. Using
this event you can requery the form at any predetermined interval. Be
careful though, this also changes the current record so you may want to
cache the id of the current record and use additional code to reposition the
form to this record after the requery.
 
Back
Top