I'm stuck.
I have a sub-form that is a datasheet view. What I want to do is to hide a column depending on the UserDisplayName(). I can get it to trigger easily enough but when I try to hide a field I get this:
Sorry, there's a problem. The property selected is invalid for this type of control.
Here is my "code":
SetProperty
Control Name: StatusComboBox
Property: Visible
Value: False
The problem is that it works fine on the calling form (for a different control), just not on the subform so I know that the "syntax" is correct.
There must be a trick that I am missing.....
I have a sub-form that is a datasheet view. What I want to do is to hide a column depending on the UserDisplayName(). I can get it to trigger easily enough but when I try to hide a field I get this:
Sorry, there's a problem. The property selected is invalid for this type of control.
Here is my "code":
SetProperty
Control Name: StatusComboBox
Property: Visible
Value: False
The problem is that it works fine on the calling form (for a different control), just not on the subform so I know that the "syntax" is correct.
There must be a trick that I am missing.....