Option Group GoTo Page Break

  • Thread starter chopper57 via AccessMonster.com
  • Start date
C

chopper57 via AccessMonster.com

I have a Option Group that presently opens a popup form, I want to change the
setup by placing the forms as subforms and placing page breaks.
I don't know what to write in the case statement for pagebreaks.

This is what I have now for popups:

Private Sub optEnrollment_Click()
Dim strForm As String
Select Case optEnrollment
Case 1
strForm = "frmPlanAsSs"
Case 2
strForm = "frmPlanAsSs"
Case 3
strForm = "frmPlanAsSs"
Case 4
strForm = "frmPlanAsSs"
Case 5
strForm = "frmPlanAsSs"
Case 6
strForm = "frmPlanAsSs"
Case 7
strForm = "frmPlanTKD"
Case 8
strForm = "frmPlanAsSs"
Case 9
strForm = "frmPlanTKD"
End Select
DoCmd.OpenForm strForm, acNormal
End Sub

I have to forms that open depending on which class is chosen, from what I've
seen on the site a lot of people say this is a better way then popups.
 
R

Rick Brandt

chopper57 via AccessMonster.com said:
I have a Option Group that presently opens a popup form, I want to change the
setup by placing the forms as subforms and placing page breaks.
I don't know what to write in the case statement for pagebreaks.

I'm sorry..."page breaks"? The use of page breaks in forms died with Access 2.
Where and why would you want to use a page break in a form?

You can have a single subform control and have your option group change the
SourceObject property of the control to determine which form is displayed
within. I can't see how a page break is relevant to that.
 
C

chopper57 via AccessMonster.com

Well Rick, my forms I'm trying to use are popup forms for choosing a class
and inputting data.
From what I've seen on the site a lot of people suggest placing them as a
subfrom with page breaks vs popup because a popup doesn't link.
 
R

Rick Brandt

chopper57 said:
Well Rick, my forms I'm trying to use are popup forms for choosing a
class and inputting data.
From what I've seen on the site a lot of people suggest placing them
as a subfrom with page breaks vs popup because a popup doesn't link.

I understand the "change them to subforms" part, but still have no idea what
"page breaks" has to do with this. Do you mean placing the subforms onto
TabControl pages?
 
C

chopper57 via AccessMonster.com

I got it to work just by placing Me.GoToPage in the case statement.
What I have is a subform and option group with additonal subforms on the form
located below the main information block, when you select an option it will
jump down to the subform located at the page break.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top