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
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