I have a subform that is simply displaying a table that is linked to the current record on the main form. The subform is showing certain fields which I would like to hide on the subform view but still be visible on the table. I tried the following code:
Private Sub Form_Load()
Me.[AuditTrailID].ColumnHidden = True
but I get the following message when Access gets to the sub form load:
"Run-time error 2465:
DatabaseName can't find the field '|1' referred to in your expression"
The table is a linked table in a backend access database, the form/subform are in the front end.