I have a form view where users can see a listing of all clients which is fed
by a query called ClientBrf. On this same form is a button that users can
push to be prompted for a client name or a portion of a client's name in
order to search the listing and have it filter down the results. Hitting the
button and leaving the prompt blank will return the full client listing
again. This button no longer works now that I am working in Access 2007.
Anybody have any ideas why this might be? I've included the button's
underlying code for information.
Private Sub FilterClient_Click()
On Error GoTo Err_FilterClient_Click