Refreshing Data in Form From Linked Table Created by another user.

  • Thread starter Thread starter PaulHilgeman
  • Start date Start date
P

PaulHilgeman

I have a slit database, pretty standard set-up etc.

When one user creates a new record on their computer, the new record
can not be found on any other computers until they exit their main form
and go back into the main form. They do not need to exit Access and
get back in.

Is there a way to automate this process, so taht I can just add a
refresh button, or force a refresh on all client computers when a new
record is added?

Thank you,
Paul Hilgeman
 
Hi,



RECALC recompute the expressions, REFRESH reload the actual record,
REQUERY reload the recordset. So, Me.Requery is the solution to see the
records added or deleted by other, while Me.Refresh is enough to see
modifications done by other to records we already have in 'our' recordset
(open by the form, for us).

The 'problem' with Me.Requery is that it loose the current "position" of the
actual recordset, since the whole recordset is recreated... you end up
getting in the beginning of the new recordset, at its first record. Sure,
you can keep the primary key, or any other significant ID, of the actual
record, then make the Me.Requery, then, make a FindFirst to, hopefully (if
the record still exists) move to the record you were before the requery.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top