C
CY
I know this should be easy but for some reason I can't figure this out.
I need 2 buttons on a form that will filter the data. One button will show
all records that are "active" (or contain a "1" in the active field.
The other button should show all records that have something in the "Notes"
field. I can easily do either manually by right clicking and choose (in the
first case) filter by selection or (as in the second case) filter excluding
selection when on an empty notes field. But I can see this will be a
problem later once we start getting less active records and less fields
without notes.
How do I do this on a button so that the button will see "Filter ACtive
Records" and "Filter Accounts with Notes".
TIA
CY
I need 2 buttons on a form that will filter the data. One button will show
all records that are "active" (or contain a "1" in the active field.
The other button should show all records that have something in the "Notes"
field. I can easily do either manually by right clicking and choose (in the
first case) filter by selection or (as in the second case) filter excluding
selection when on an empty notes field. But I can see this will be a
problem later once we start getting less active records and less fields
without notes.
How do I do this on a button so that the button will see "Filter ACtive
Records" and "Filter Accounts with Notes".
TIA
CY