J
Joop
Hi Allen,
I hav tried different ways to fill the form properties with the right values
but in the state the subform is, after using the formfilter and applyfilter
from the menu, it does not allow me to change any property from VBA.
When I compare the same situation in Access XP and Access 2003 I see that
after using FormFilter and Apply filter from the Access menu in AccessXP
both parent and child form ar filtered. When I do the same in Access2003 the
parentform is filtered but when I switch to the childform (it is on a
different tab-page) it still has the filter tabs ("look for" and "or") at
the bottom. Then when the subform has the focus I can hit "ApplyFilter" in
the command bar and everything is ok.
Your suggestion to use link fields is no solution for me because the form
represents a n to n relation between to tables using a cross-link table (is
that propper english?). I want to have full control over the tables from
VBA.
I also tried .runcommand acCmdApplyFilterSort but then the childform has to
have the focus and it does not allow me to give that. So I wil probably make
a work-arround so I don't need the vommandbar-filtering anymore........
Unless you have more ideas
The problem looks to me like a bug.
Thanx for your reply...
Joop (Netherlands)
I hav tried different ways to fill the form properties with the right values
but in the state the subform is, after using the formfilter and applyfilter
from the menu, it does not allow me to change any property from VBA.
When I compare the same situation in Access XP and Access 2003 I see that
after using FormFilter and Apply filter from the Access menu in AccessXP
both parent and child form ar filtered. When I do the same in Access2003 the
parentform is filtered but when I switch to the childform (it is on a
different tab-page) it still has the filter tabs ("look for" and "or") at
the bottom. Then when the subform has the focus I can hit "ApplyFilter" in
the command bar and everything is ok.
Your suggestion to use link fields is no solution for me because the form
represents a n to n relation between to tables using a cross-link table (is
that propper english?). I want to have full control over the tables from
VBA.
I also tried .runcommand acCmdApplyFilterSort but then the childform has to
have the focus and it does not allow me to give that. So I wil probably make
a work-arround so I don't need the vommandbar-filtering anymore........
Unless you have more ideas
The problem looks to me like a bug.
Thanx for your reply...
Joop (Netherlands)