Solved Hide / Show column in datasheet view of subform with button (1 Viewer)

[BJF]

Hello,

I want to hide or show a column on a subform thats in datasheet view by pressing a button on the main form.

Here is the code that I tried so far on the button but neither of the code below are not working.



Forms(frmOpenOrdersByCustomer!fsubOpenOrdersByCustomer).Form.Controls("ShipToCustomer").ColumnHidden = False



Me.fsubOpenOrdersByCustomer.Form!ShipToCustomer.Visible = True
Me.Refresh


Thanks,
BJF

 

[arnelgp]

To Show:

Me!fsubOpenOrdersByCustomer.Form!ShipToCustomer.ColumnHidden = False

To hide:

Me!fsubOpenOrdersByCustomer.Form!ShipToCustomer.ColumnHidden =True

 

[BJF]

To Show:

Me!fsubOpenOrdersByCustomer.Form!ShipToCustomer.ColumnHidden = False

To hide:

Me!fsubOpenOrdersByCustomer.Form!ShipToCustomer.ColumnHidden =True

Thank you!