Hide field depending on user ID

D

Darrin

I have a form with the following fields:

[ID] [Requester] [QTY] and so on. I want to hide the fields [Approved] [Date
approved] and [Received] with the following conditions.

If the user does not belog to the support section located in
[tables].[Personnel].[Duty Section] then the fields should be hidden.

Any sugestions?
 
D

Darrin

OK for now I cheated and think I might just leave it this way. I set the open
event to false for all of the fields. Then on the open event for the P/W form
I set this.

DoCmd.OpenForm "GPC"
Forms![GPC]![Approved].Visible = True
Forms![GPC]![Received].Visible = True
Forms![GPC]![DateApproved].Visible = True
Forms![GPC]![Date Received].Visible = True
 
Top