Refreshing Data On A continuous Screen, without using ‘Requery’
Posted on 2014-11-05
I developed a continuous screen ‘frmContinuous’ for a client. The screen usually contains over a 100 records in the data set being worked on by the users. Many more than can fit on the visible screen. So the users have to scroll to get to many of the entries.
The recordsource of ’frmContinuous’ is a query combining data from multiple tables and other queries.
Each line on the continuous form has an ‘Edit’ button to the far left. When the users clicks the ‘Edit’ button they are taken to another screen, ‘frmEdit’ that allows to revise some of the information shown on the continuous form.
When the users exit ‘frmEdit’ and return to ‘frmContinouos’ they want to be positioned on the record they were edting and have the information on ‘frmContinuous’ reflect changes (if any) that had been made in ‘frmEdit’
I don’t seem to be able to accomplish both.
If I don’t execute the ‘refresh’ when they return to frmContinuous, they are positioned exactly where the information on the screen for that record does not reflect any changes they made.
If I execute a ‘Me.Requery’ when I return to frmContinuous’ the updated information is shown on the screen. However, it also repositions the cursor to the first record on the screen. This is particularly time consuming for them because they may have to scroll thru many records to get back to the record they want to work on next.
Is there any way to accomplish both objectives when returning to the continuous for?
1. Maintain the position in the recordset
2. Update the information shown on the screen for that record.