Filter Subform with an On Click Event

[Elana]

I'm spacing out here - I have a subform that displays a datasheet list of "to do" items for a particular insurance claim. I want to be able to filter the "to do" records with a command button where the user can show all "to do" items or only those items that are currently outstanding.

I want the command button to be on my main form. I'm struggling with how to code this. I was hoping I could specify record source for the subform in code and then use a SQL statement limiting the records, but I'm not having much luck there.

I'll appreciate any ideas to get me on the right track. Thanks.

 

[Elana]

Never mind - I figured it out. I was having a case of the vapors -