Hide field depending on user ID

G

Guest

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?
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I format a field based on the value 1
Hide extra fields in a Continuous Forms 5
Using Two Fields on a Form to Select Email Addresses from a Table 7
show field depending on checkbox 12
Bound Fields 4
Sum row value across multiple columns 2
Lock field after it has been updated via an other form 1
Problem with form displaying message for date field with code for checking ISNull in Exit event 4

Top