Can someone review this code please, I'm not sure were it's gone wrong
While running the code Visual Basic 6, pops up with this message. Run-Time error "91"
object variable or with block variable not set.
I am hoping I can enter the ID of the customer in a textbox which is named "mSearch.Text" and for it to pop up with the record found displaying the information in another form.
The data is supplied via Microsoft Access using ODBC.
Private sub Button1_Click
Adodc1.Recordset.Find "Customer_ID = '" & Trim(mSearch.Text) & "' "
If Adodc1.Recordset.EOF Then
MsgBox "No Records Found... Try Again"
MsgBox "Records Found"