Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    560
    Thanks
    17
    Thanked 2 Times in 2 Posts

    Limiting Combo Entries (2000/SR1)

    I have a form with a combo box that the supervisors use, where employees are assessed points based on attendance. Because mistakes happen, an entry can be deleted, but only by an administrator. In order to keep complete tracking of the employees, I have also put in some "adjustment" entries. Is it possible to limit the availability of those entries, in the same combo box, to only the administrators?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Limiting Combo Entries (2000/SR1)

    Do you use User Security ? If yes, you can set row source of the combo based on the CurrentUser.
    Otherwise, you can ask for a password or user name when the form opens and set the row source of the combo according this. This is not very safe if the user have access to the code where he could read what to input. An MDE could prevent this.
    Francois

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •