Hidding columns in a subform

[Annnnn]

Hi!



I am trying to hide certain columns in a subform but somehow it doesn't work

My subform shows more columns than I need for one application,
so upon a button click I run a certain SQL code (via VBA) and with the same click I would like to hide the abundant columns.

Private Sub btCompose_Click()


'shows the new samples that have to be in an experiment


Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim VarItm As Variant
Dim strCriteria As String
Dim strSQL As String




Set db = CurrentDb()
Set qdf = db.QueryDefs("qrBiopt_iso")




strSQL = "SELECT tblSamples.Sample_name, tblSamples.Primary_tumor_type, tblSamples.Biopsy_material, tblSamples.Sample_barcode AS [Biopsy barc 1], " & _
        "tblSamples.Biopsy_barc_2, tblSamples.Biopsy_barc_3, tblSamples.Biopsy_barc_4, tblSamples.Coupes_barcode, tblSamples.Pathologie_exp , tblSamples.Tumor_ " & _
        "FROM tblSamples " & _
        "WHERE tblSamples.Pathologie = 'Finished';"
        
qdf.sql = strSQL


Set db = Nothing
Set qdf = Nothing


'change record sourse for the subform to match strSQL, and update the subform
Forms!Biopsy_iso!Sub_iso_biopsy.Form.RecordSource = strSQL

'suppose to hide patient name collumn but doesnt work
Forms![Biopsy_iso]![Sub_iso_biopsy].Form![Patient_name].ColumnHidden = False




End Sub

I thought it wouldn't be this complicated but somehow I do something wrong...

[isladogs]

Why use code if you don't want to ever see the columns
For a datasheet, right click the column(s) and select Hide Columns
For Single or Continuous forms, remove the controls or set as visible=false

[Gicu]

To hide the column you set the ColumnHidden to True:

Forms![Biopsy_iso]![Sub_iso_biopsy].Form![Patient_name].ColumnHidden = True

[Annnnn]

To hide the column you set the ColumnHidden to True:

Forms![Biopsy_iso]![Sub_iso_biopsy].Form![Patient_name].ColumnHidden = True

haha so close yet so far! Tnx

@ridders52 I'm using the same subform for multiple applications, some need extra columns then others. To avoid abundant columns i would like to hide some depending on the code that is running

[isladogs]

Fair enough.
I have to admit I didn't notice the true/false error myself either