I have a main form where, on the main form's On Open event, it changes the properties of a subform query by hiding/showing a column, depending on the user's permission level:
Private Sub Form_Open(Cancel As Integer)
If IsUserInGroup("CostPrice") = True Then...