PDA

Click to See Complete Forum and Search --> : ADO WillMove vs. MoveComplete


JPRoy392
Sep 6th, 2000, 06:26 PM
Please Help!

In my current project, I have determined that I am going to need the MoveComplete method(I think). It seems to be acting exactly like the WillMove method. Let me explain:
Whenever I move to the "next" or "previous" record in a RecordSet, all the textboxes are updated properly, but the Tabs in the MS SSTab enabled property is always "one step behind".
Code:

Private Sub Adodc1_MoveComplete(ByVal adReason As ADODB.EventReasonEnum, ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)
Tabs.TabEnabled(2) = False
Tabs.TabEnabled(3) = False
Tabs.TabEnabled(4) = False
Tabs.TabEnabled(5) = False
If txtType.Text = "Sheet" Then
Tabs.TabEnabled(2) = True
Tabs.TabEnabled(3) = True
ElseIf txtType.Text = "Thermo" Then
Tabs.TabEnabled(4) = True
ElseIf txtType.Text = "Docutech" Then
Tabs.TabEnabled(5) = True
End If
End Sub

This example is the MoveComplete method. I have identical results if the code is placed in a WillMove method. Any help is greatly appreciated.