open another form from inside a form with using subform

[dsmithe]

I have a form named comboform that has a navigation bar and 3 subforms: application, permit, and certificate. The form permit is going to change but that change can't affect past data. I.e. If I look at a permit from last year it should look like the form from last year. The form permit will be changing often over the next few years. I don't want to keep adding subforms to comboform. I have the following permit forms:
permit - current permit form


permit2013-20180888 - permit form used from 2013 to September 1st 2018
permit2007-2012 - permit form used from 2007 to 2012

I already have the logic to call the different forms:

        If permitno < 20180888 And permitno >= 20130000 Then
          DocName = "permit2013-20180888"
        ElseIf permitno < 20130000 And permit >= 20070000 Then
          DocName = "permit2007-2012"
        Else
          DocName = "permit"
        End If
        
        DoCmd.OpenForm DocName, A_NORMAL

however when the form opens the navigation bar disappears because it is a part of comboform and not a part of the permit form. Is there a way open the other permit forms with navigation without including them in comboform? Can 1 subform open different forms? I.e. have a blank subform in comboform and when I click on permit in the navigation bar, the logic above is called, and the correct permit form name is put in the subform.

[ranman256]

If you constantly change the permit, you will have to change the form too.
Instead of making subforms (tho you can) just make a full form to enter data. (tho its still bound to the master record)

to me, you only need to enter the fields, you dont need the form.
once you enter data into the fields, the new form can be 'filled'.
no need to save old forms, just save the PDF. This way you only have 1 subform at all times.

[June7]

Certainly should be able to set SourceObject property of subform container control. One method uses BrowseTo command https://msdn.microsoft.com/en-us/vba...-method-access

However, I agree that data entry form does not have to exactly mimic paper form in appearance. Life will be simpler if you don't try to. Changing form does not change data. If you need the data output in a specific format, use report.

[dsmithe]

The form changes are just adding and removing fields. What I want to do when I make a change is make a copy of the form, paste with a new name which becomes the old permit form, change the permit form, add a little logic to the form which selects the correct form based on the permit number that was entered. I didn't want to have to all of that and add a new subform to comboform. So now I have:

If permitno < 20180888 And permitno >= 20130000 Then
  Forms![ComboForm]![Permit].SourceObject = "permit2013-20180888"
ElseIf permitno < 20130000 And permit >= 20070000 Then
  Forms![ComboForm]![Permit].SourceObject = "Permit2007-2012"
Else
  Forms![ComboForm]![Permit].SourceObject = "permit"
End If

and things are working the way I want. Even when scrolling one at time the permit form changes when necessary. I think I will change the If Then ElseIf logic to a select case in the near future.

Thank you for the suggestions.

[June7]

What I have done is to have 1 form and code behind that form manages display of controls and/or sets ControlSource property. But perhaps the differences between your permit forms are extreme enough to make that more unwieldy than maintaining multiple forms.