I added "Find Record" and "Find Next" buttons using the Access 97 wizard. However, they don't work. When you click the button it launches the dialog box. You enter your search criteria and it can't find anything. For example, I put my cursor in a field named "Title" on a form named "InventionDisclosures", clicked "Find Record", and entered the word "Diesel" using any part of the field. It returns a response that it can't find anything. Do these buttons need to be synced with anything? I have combo box (Cbnumber)on this form. Here is the code for the "Find Record" button.
Private Sub CbFindRecord_Click()
On Error GoTo Err_CbFindRecord_Click
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_CbFindRecord_Click:
Exit Sub
Err_CbFindRecord_Click:
MsgBox Err.Description
Resume Exit_CbFindRecord_Click
End Sub
What am I doing wrong? Please Help.
Private Sub CbFindRecord_Click()
On Error GoTo Err_CbFindRecord_Click
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_CbFindRecord_Click:
Exit Sub
Err_CbFindRecord_Click:
MsgBox Err.Description
Resume Exit_CbFindRecord_Click
End Sub
What am I doing wrong? Please Help.