I'm new in VB6, and i'm having an error message while debugging...after the login checking, I need to open the form to select a project code from my Access db. The error was stop at RS.OPEN. and prompt the error message "Method or data member not found". Now, when I try to retype the words RS. but I do not found "Open" object anymore. Can anyone help and advise me what mistake I have make? Or any component I need to add in order I can select the "object OPEN"? Please help!
Private Sub Form_Load() Dim RS As Recordset Set RS = New ADODB.Recordset GetDB RS.Open "Select ProjectCode from PrjDetails", Mydb, adOpenKeyset If RS.RecordCount > 0 Then RS.MoveFirst Do While RS.EOF = False PrjCode.AddItem RS!ProjectCode 'PrjCode.List(PrjCode.ListCount - 1, 1) = RS!ProjectCode RS.MoveNext Loop End If RS.Close Set RS = Nothing End Sub