Subform Datasheet View

[bunji]

I have a subform that is in databsheet view. When the user logs in to the db it sets the global variable with the group level they have.

I would like a column to be hidden for a certain group of users and have tried the following.

On the subform opening event i have

if vlevel = "engineer" then

me.Hours.columnhidden = True

Else

me.Hours.columnhidden = False

End If

And i have done the same on the Main Form open event identifying the subform by Form!Subform![Hours].columnhidden = True

But neither worked.

Can any suggest something.

 

[alastair69]

try Me.hours.Visible = False

 

[bunji]

I tried that and it also did not work.

 

[bunji]

I tried that and it also did not work.