filter on continuous form

[Guest]

How do I filter a datafield on a continuous form by whether or not the data
fields are > 0?

I want this to be a procedure 'on click' of a field label...?

Is this even possible?

HELP!

 

[Guest]

You need to modify the recordsource sql in the form which is activated by the
onclick or on dblclick event for your label. To work out the required sql,
create a query where a criteria is field>0. click of the sql button and copy
and paste the text into your code which will read something like
me.recordsource=sqlstr. Note you will have to have a means to reset the
recordsource back to the original.

This will 'preserve' the use of the access filter keys.