Filter/Search button not working in Access 2007

S

Smitee2006

I have a database which manages client contracts. I have a form which uses a
datasheet list to see all clients in the clients table and there is a button
set up to Filter/Search for a specific client. The user is able to select the
button and enter all or a portion of a client's name and upon selecting OK
the client listing will be filtered down to just those client's meeting the
specific criteria. Then the user can select the client record by selecting an
expand button alongside the client name(...). Now the button that was set up
in Access 2003 no longer works...all other buttons on the form work. I've
included the code attached to the button for review.

Private Sub FilterClient_Click()
On Error GoTo Err_FilterClient_Click

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 2, , acMenuVer70

Exit_FilterClient_Click:
Exit Sub

Err_FilterClient_Click:
MsgBox Err.Description
Resume Exit_FilterClient_Click

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top