By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,971 Members | 1,604 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,971 IT Pros & Developers. It's quick & easy.

Help...Filter Subform Wirth Main Form Button

P: n/a
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

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.