Do Actions on Only Filtered Records

[LarryP]

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?

 

[Alex Dybenko]

Hi,
you can either read subform's form filter property and then build update
query based on this filter, or use .recordsetclone property to get form's
recordset and update flag using it

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[LarryP]

Thanks, Alex, I'll try those.

Hi,
you can either read subform's form filter property and then build update
query based on this filter, or use .recordsetclone property to get form's
recordset and update flag using it

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com