This is a discussion on Requery Option Group within the Microsoft Access forums, part of the Question Forums category; I have an option group on a form, which I am using to open some forms in my database. One ...
I have an option group on a form, which I am using to open some forms in my database. One of the option buttons opens a parameter form for my reports.
When I choose this option the form opens and I enter my criteria for the report and then preview it.
The form with the option group is still loaded so if I wanted to preview a report with different criteria, because that option in the option group is selected, I have to close it and reopen it to select that option.
Is there any way to requery the option group.
This is the code I have used. I have added:me.optMenuChoices.requery at the beginning and just after the end select but it is not working.
Any help is greatly appreciated.Code:Private Sub optMenuChoices_AfterUpdate() Select Case Me.optMenuChoices Case 1 DoCmd.OpenForm "frmClientDetails", acNormal, , , acFormAdd Case 2 DoCmd.OpenForm "frmClientSearch", acNormal, , , acFormAdd Case 3 DoCmd.OpenForm "frmInspections", acNormal, , , acFormAdd Case 4 DoCmd.OpenForm "frmContacts", acNormal, , , acFormAdd Case 5 DoCmd.OpenForm "frmClientReports" End Select End Sub