Filter macro stopped working in 2007

C

Clddleopard

I have a DB I set up in Acc 2003 with a filter macro that worked great. Now,
in 2007, it works once, but even after I remove all filters, it filters for
the first criteria that was put in.
The macro is attached to a button
The form has fields such as:
FirstName
LastName
EmailAddress

The macro is a macro group
Macro Name: FirstName
Action:ApplyFilter
FilterName:FirstNamefilter (which is a query with the SQL SELECT
addressediting.[FirstName] FROM addressediting WHERE
(((addressediting.[FirstName]) Like
"*"&[Forms]![Addresseditingfrm]![entername]&"*"))

Macro Name: LastName
Action:ApplyFilter
FilterName:LastNamefilter (which is a query with the SQL SELECT
addressediting.[LastName] FROM addressediting WHERE
(((addressediting.[LastName]) Like
"*"&[Forms]![Addresseditingfrm]![enterlastname]&"*"))
etc...

Is there something simple that I've missed? I do have a macro name
"Allrecords" that executes the ShowAllRecords action. It does show all
records, but it doesn't let the filter run a second time with a new criteria
from the text boxes.

I'm kind of sad about all my hard work in Acc2003 randomly breaking in 2007.
Please help!

Clddleopard
 

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