Filter out rows iteratively?

[Access9001]

I want to be able to go down my rows and, with VBA, filter out any number of arbitrary rows. I'm not looking into hiding rows but rather filtering them so I can always turn them back on later with .ShowAllData.. Is this doable?

 

[Pat Hartman]

Not the way you are describing it. The way you are describing it would require a field in the table that you would check to indicate "Hide". You would then need a query to unhide all or show all so you could choose which items to unhide.

Filtering in a relational database is done with criteria. You include/exclude children under 18, addresses in Connecticut, etc.

 

[Access9001]

Alright, I will look into another way. Thank you.