I have a form "Order Summary"(main form) and two sub forms. I would like to display one or the other sub from based on a check box (retail) on the main form. This is "on current" of form.
Me.ShipToAddressTablesubformRetail.Visible = Me.Retail
Me.Ship_To_Address_Table_subform.Visible = Not Me.Retail
I have also tried this
If Me![Retail] = True Then
Forms!OrderSummary.Form.ShipToAddressTablesubformRetail.Visible = True
Forms!OrderSummary.Form.Ship_To_Address_Table_subform.Visible = False
Else
Forms!OrderSummary.Form.ShipToAddressTablesubformRetail.Visible = False
Forms!OrderSummary.Form.Ship_To_Address_Table_subform.Visible = True
End If
Me.ShipToAddressTablesubformRetail.Visible = Me.Retail
Me.Ship_To_Address_Table_subform.Visible = Not Me.Retail
I have also tried this
If Me![Retail] = True Then
Forms!OrderSummary.Form.ShipToAddressTablesubformRetail.Visible = True
Forms!OrderSummary.Form.Ship_To_Address_Table_subform.Visible = False
Else
Forms!OrderSummary.Form.ShipToAddressTablesubformRetail.Visible = False
Forms!OrderSummary.Form.Ship_To_Address_Table_subform.Visible = True
End If