In access 2000 I need to filter records in a Subform by pushing a
button on a command button located on the Main form.
The Main form is blank. Its only purpose is to contain the subform
which is in a datasheet format.
So far…
1)I have created a query called "CatFilterQuery" which results in a
prompt to enter the "category field" to filter on.
2)Created a macro called "FilterCategory" which is based on the query
mentioned above and uses the macro item ApplyFilter.
3)Applied the macro to a command button located on the main form.
Here's the problem:
The command button macro isn't pointing to the field "category" in the
subform. Therefore it won't run. Is there another macro I need to
state in the macro builder ahead of the ApplyFilter macro? Btw, I did
try an expression in the Where Condition of the ApplyFilter macro
which pointed to the subform and field that I wanted to filter. That
didn't work.
Any suggestions (not related to writing VB code) would be greatly
appreciated.
Thanks
