how to hide a subform's ID field 2

[cfvcf]

I have a form that has a subform, the subform has a field called ID, which means nothing to the user, but it does to the code. I have the properties set to visible NO and also when I open the form that uses the subform, I set it to visible = false, but it still displays. What am I missing?

Thanks!

 

[PaulBricker]

In the Form_Current event put

Me.Controls("NameOfControl").ColumnHidden = True



Paul

 

[PaulBricker]

Sorry, it is the Form_Current event, but it's for the subform current event, not the main form.

Paul

 

[cfvcf]

Great, I'll look at this in the morning. Guess I thought it would be the .visible. Haven't tried the hidden!

 

[MajP]

Is the subform in datasheet view?

Note The ColumnHidden property applies to fields in Datasheet view and to form controls when the form is in Datasheet view.

Hiding a column with the ColumnHidden property in Datasheet view doesn't hide fields from the same column in Form view. Similarly, setting a control's Visible property to False in Form view doesn't hide the corresponding column in Datasheet view.

 

[cfvcf]

I coded the columnhidden in the open of the subform which is a datasheet and everything works great! Thanks!