I am trying to connect to an access 2000 mdb database file. I am trying to make a form with the Vb data form wizard but its not working!. I am completing all the steps to finish (Data form created) hooray.. but when I run the form I get an error message: Compile Error. Procedure declaration does not match description of event or precedure having the same name, and Highlights the code below: Private Sub datPrimaryRS_MoveComplete(ByVal adReason As ADODB.EventReasonEnum, ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset
datPrimaryRS.Caption = "Record: " & CStr(datPrimaryRS.Recordset.AbsolutePosition)
Yes I have service pack 6 installed. Really strange this one, I cant beleive that even in the data form wizard is not working. why.... I have tried access 2000 mdb and access 97, all goes well through the wizard until I run the form. It has to be something really simple- someone must have the answer.