472,142 Members | 1,350 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,142 software developers and data experts.

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

Nov 12 '05 #1
0 2512

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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.