I'm designing an Entity table (holds people, business, etc.) that will have (later in production) hundreds of thousands of records.
The Form for Entity has a SQL source that limits the recordset to a few dozen local and active records.
An attached Search command button is used to find a particular record.
Authorized users can use the Entity form to VIEW records.
Fewer authorized users can EDIT the Entity record.
A locking procedure(s) I wrote a prohibits a user from EDITing if the record is locked,
in which case they can wait (keep pressing the EDIT command button until it unlocks) or move on to another record.
Because many users will use this form, and may all have it open for extended times;
If a user is going to edit, I want the newest data if the record was locked or even if it wasn't seen as locked by this user (they were viewing a previous record and just now moved to one that was modified) when just VIEWing or starting EDITing.
I'm looking for a way to REFRESH just the current record and not requery or refresh the entire recordset (trying to cut down on network traffic while not waiting for the refresh interval to trigger).
Is there a way to REFRESH just a particular record in the Private Sub Form_Current() procedure?
(I searched around here and in Google and couldn't find this mentioned)
Thanks