I have a (datasheet view) form that has link column with a click event.
This form may have 1000 records in it and they are sorted on a particular column (Money) descending order.
The process is for management to work their way down the list and "select" particular records for a visit.
WHen selected...an update (VBA Stored Procedure on SQL Server) takes place.
Whether I do a Me.Form.Requery or refresh doesn;t matter.
The datasheet cycles all the way to the top record.
Then management has to scroll down to where they left off
Any way to do the update and sta on that particular window/view?