S
Simone
Hello,
I have converted my database from 2002 to 2007 and my filters used with a
macro (applyFilter) works when I enter the first criteria, however if I ask
for another criteria the form comes back with the same record. Here is how my
macro is:
Note: I use a Form to Filter and it calls "CastFilterForm"
Action
SelectObject (Object Type - Form); (Object Name - InvoiceForm); (In
Database Window - No)
ApplyFilter (Where Condition [Forms]![CastFilterForm]![CompanyName]
Close (Object Type - Form); (Object Name - CastFiltForm)
It always worked fine I don't know what changed on 2007 version that is not
working. Doesn't seem to be a problem with the code itself... Any ideas?
Thanks
Simone
I have converted my database from 2002 to 2007 and my filters used with a
macro (applyFilter) works when I enter the first criteria, however if I ask
for another criteria the form comes back with the same record. Here is how my
macro is:
Note: I use a Form to Filter and it calls "CastFilterForm"
Action
SelectObject (Object Type - Form); (Object Name - InvoiceForm); (In
Database Window - No)
ApplyFilter (Where Condition [Forms]![CastFilterForm]![CompanyName]
Close (Object Type - Form); (Object Name - CastFiltForm)
It always worked fine I don't know what changed on 2007 version that is not
working. Doesn't seem to be a problem with the code itself... Any ideas?
Thanks
Simone