Results 1 to 3 of 3
  1. #1
    banpreet is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2016
    Posts
    117

    Button that will show certain fields on form

    I have a form with different sections that go through an approval process. When the customer opens up the form, all he can see is section 1 and 2, only section 1 is to be filled out by the customer. My boss wants the 2nd section hidden because they are not supposed to fill it out. When customer fills out section 1, there is a button that sends an email to the person to open up the form and fill out section 2. How do I make it that after that button is pressed, when the person opens up the form they see section 2 instead of the customers seeing in the beginning.

    The button is called command270. If somebody can post the code that would be helpful.

    Thanks!

  2. #2
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    349
    For this you will need to know who is logged in at the time and set visibility based on that. So, you will need to add login functionality to your database (google for many examples). Then you will have a table of users - tblUsers. You can have a field in this table for SecurityLevel. Then on open of your form show Section 2 only if SecurityLevel is >= to a value you select that would be allowed to see Section 2.

  3. #3
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    You share your db with customers?? Or is this web based?
    If you're sharing, know that there is little you can do do prevent the db from being examined to discover how to undo whatever you decide to do. So if the invisible stuff is business sensitive or private, better come up with some other method, for which there are no doubt several possibilities.

    Plus, the open even would be OK if the data that has to be examined (such as user name or level) is not part of the form. If it is, you'll have to use the Load event.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 11-21-2014, 09:56 PM
  2. Replies: 2
    Last Post: 12-09-2013, 09:35 AM
  3. Replies: 6
    Last Post: 07-12-2013, 01:23 PM
  4. Replies: 3
    Last Post: 11-18-2012, 12:49 PM
  5. Replies: 8
    Last Post: 11-08-2011, 05:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums