Using Visual Basic 6.0 Pro to set a Command Button To Search an Access Database with ADODC and DataGrid

[Suiadan86]

Hi, I'm trying to setup a form to search a Database via a textbox and display the results in a data grid. Here's the code i have so far. - I hope someone can help:

Private Sub Command1_Click()
Call clearall(Me)

End Sub

Private Sub Command2_Click()
Adodc1.Recordset.AddNew
MsgBox "Sucessfully Added"
End Sub

Private Sub Command3_Click()
Adodc1.Recordset.Delete
MsgBox "Sucessfully Deleted"

End Sub

Private Sub Command4_Click()
Adodc1.Recordset.Update
MsgBox "Sucessfully Updated"
End Sub

Private Sub Command5_Click()
Adodc1.Recordset.Find "MembershipNumber='" & Val(Text5.Text)



End Sub

Continue reading...