Access ADP subform refreshes / fickers as many times as rows in the datasheet it contains
Posted on 2006-07-07
I have a main form and a subform. In the OPEN event for the subform the code below is executed. The subform displays the results in datasheet format. There are no Master / Child links. The LogonID stored on a hidden & minimized form is used to retreive the rows in the SavedActivity table. The stored procedure has 1 parameter, @UserID, which is the primary key for the table.
The resulting recordset produces exactly what I want; but when the focus is placed on the subform when a staffer clicks on any row on the subform, the datasheet in the subform "flickers / refreshes" about as many times as the number of rows returned. This "refresh" happens only the first time any row is clicked on or the scroll bar moved. After a staffer posts the updated row, then the problems reoccurs again.
The "refreshs" can take a long time to finish compared to the 1 - 2 second time it takes for the form to display the results. I do not invoke any refresh / requery / repaint methods.
I have tried playing with every setting I could find, but I don't know causes the problem or how to fix it.
Could someone please help?
Dim strParm As String
strParm = "Execute stpSavedActivity_ByID '" & Forms![frmSetup01]![LogonID] & "'"
Me.RecordSource = strParm