469,915 Members | 2,508 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,915 developers. It's quick & easy.

Help...Filter Subform Wirth Main Form Button

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
Nov 12 '05 #1
0 2338

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Andante.in.Blue | last post: by
2 posts views Thread by William Wisnieski | last post: by
2 posts views Thread by cefrancke | last post: by
3 posts views Thread by dhowell | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.