Form does not filter subforms based on the option group which is set to default.

[Amy27]

Hi..
I have an option group in my mainform and is set to default for "This Week" assuming it would filters the sub form based on the default field when the form is open.But i am not able to see that.
When i open the form the option group by default selected to "This Week" but it does not filter the subfoms according to the default value set.
How can we do that..


Can anyone help me in this..

Thanks

[pbaldy]

Does it work if you select another option and then "this week"? The same code would have to be applied when the form opens (load event) as when you change selections.

[Amy27]

Thank you so much...It worked..

[pbaldy]

Happy to help!