Monitor completion of Requery on ADP Form

Hello Experts,

I have a form in a Access 2003 ADP connecting to Sql backend. It opens a separate dialog to update values in the underlying recordset. Upon returning from the dialog, I do a requery of the form and then reposition the form back to the original record, using the following code:

    'requery to get the update back on the main form
    Me.Requery
   
    Set rsadd = Me.RecordsetClone
    rsadd.Find "ParcelID = " & Str(EditRecordId)
    If Not rsadd.EOF Then
        Me.Bookmark = rsadd.Bookmark
    End If
    Set rsadd = Nothing
 
The problem is that the repositioning tries to occur while the requery is still asynchronously executing, so the reposition does not happen.

I have searched for a property or event to monitor, to discover when the requery is complete, but  I have not been able to find one. I have tried the connection object still executing, but the values appears not to change.

I have built this kludgey work around,

  ' workaround I would like to get rid of
        x = 999999
        Do While Me.Recordset.RecordCount <> x
             x = Me.Recordset.RecordCount
             wait = Timer + 1
             Do While Timer < wait
              DoEvents
             Loop
        Loop

but I would like to get rid of it. On the form, I can visually see the navigation bar change (the red X disappears) when the requery is complete, but I have not been able to find a way to detect that.

Is there a property or event to monitor, to test for the completion of the requery?
Is there a application level property that will force the requery to be synchronus?

Thanks.







 
Start Free Trial