filter on continuous form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.
 
Back
Top