I am trying to run:
This is resulting is some wonky things. It seems to work once, then not again. So I think I am referring to the main form "jobquote" incorrectly. I am creating the illusion that on a button click, a sub-form "pops up" and off the page. That way if the user wants to keep viewing that form, but navigate to a different tab they can.
For the record just in case, my main for is using:
Code:
Private Sub Form_Close()
Form!JobQuote!FloatingPriceBtn.Caption = "Pop Out Price Comparison"
Forms!JobQuote!TypeSumComparisonQry.Visible = True
End Sub
This is resulting is some wonky things. It seems to work once, then not again. So I think I am referring to the main form "jobquote" incorrectly. I am creating the illusion that on a button click, a sub-form "pops up" and off the page. That way if the user wants to keep viewing that form, but navigate to a different tab they can.
For the record just in case, my main for is using:
Code:
Private Sub FloatingPriceBtn_Click()
If Me.FloatingPriceBtn.Caption = "Pop Out Price Comparison" Then
DoCmd.OpenForm "FloatingPriceComparison", acFormDS, , , , acDialog
Me.TypeSumComparisonQry.Visible = False
Me.FloatingPriceBtn.Caption = "Close Price Comparison"
Else
Me.FloatingPriceBtn.Caption = "Close Price Comparison"
DoCmd.Close acForm, "FloatingPriceComparison"
Me.TypeSumComparisonQry.Visible = True
Me.FloatingPriceBtn.Caption = "Pop Out Price Comparison"
End If
End Sub