Hello. The code below is for a program that uses the classis Access sample database called Biblio.mdb . The controls on the form are: 1 commmand button, 1 Datagrid control, 1 textbox, and 1 ADO Data Control.

Option Explicit

Private Sub Form_Load()
 txtUserQuery.Text = Adodc1.RecordSource
 Adodc1.Caption = Adodc1.RecordSource
End Sub

Private Sub cmdQuery_Click()
 On Error Resume Next
 cmdQuery.Enabled = False
 Adodc1.RecordSource = txtUserQuery.Text
 Call Adodc1.Refresh
 Adodc1.Caption = Adodc1.RecordSource
End Sub

Private Sub Adodc1_MoveComplete(ByVal adReason As ADODB.EventReasonEnum, ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)
 cmdQuery.Enabled = True

My question is, why use the event MoveComplete? How does it differ from
RecordsetChangeComplete and RecordChangeComplete??? I've already read
their definition but I can't tell them apart. I've also tried
substituting it with the other two Events but they don't work. Can you
give me a simple program that uses RecordsetChangeComplete and
RecordChangeComplete? If not, please explain them in layman's terms.
Beginner here. thanks guys!!!!
End Sub

10 Years
Discussion Span
Last Post by debasisdas
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.