Access 2003/Windows XP -- have a form and subform. For a given record in
the form, subform can have up to several thousand records. Subform
records
include a flag field that can be used to perform certain batch actions on
flagged records. Subform has a button that will flag ALL subform records
for
batch action, or the user can individually flag selected subform items.
With
potentially thousands of records, though, individual flagging can be
tedious.
Have determined that when the subform is filtered to show only selected
records, my "Flag All" button still flags ALL records, not just the ones
displayed in the filtered subform. Need suggestions on how to modify my
"Flag All" VBA so that it applies whatever is the current filter on the
subform, so that "All" actually means "All that I'm seeing right now."
What's the property of my subform that contains the currently active
filter
SQL?
|
