Option Group

[Novice1]

I have a form with an option group. Within the option group I have a series of queries (all records, closed records, open records, etc.) to sort the data. Everything works fine.

My issue is a cosmetic one. When I change the query via running a report versus the option group, the option group doesn't reflect the correct status (e.g., I run a report for all closed records but the option group still shows All Records). I

n my VBA, is there a line I can write to change the option group appearance from All to Closed, without clicking on the option group itself?

Thanks

 

[dmattarn]

you could probably accomplish this by using some code in an "event" without more detail i can't get specific on an answer