title: Access - Make a subform field no visible with a button on the parent form :)
body: <p>I have an access database with a parent form which has a subform in datasheet view. The subform has advanced fields that don't need to be visible all the time, lets go with one field "productcode" in subform "deliverylines", parent form is "deliveryheaders". So i need a button the main form that will make the "productcode" column visible. </p>
  
  <p>This is what I've been trying but its just throwing errors at me :( </p>
  
  <pre><code>    Private Sub showadvanced_Click()
  Me.DeliveryLines.Productcode.Visible = True
  end sub
  </code></pre>