I have a form with a datasheet subform which has users adding data on an active basis. I have the timer even to do a me.refresh and a me.requery (for update of a query for a different part of the form), but the problem I have is that it resets the cursor position on the form. If a user has the active record on the 5th record, for example, after the refresh and requery, the cursor position jumps back to the 1st record. Is there anyway to have the data update unobtrusively? This form must remain open at all times.
