Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Restrict View (2000)

    Have a form and sub form, the main record is managers name with the team players in the sub form. The form is used for managers to change team players. I wish to restrict the form so that when a given manager opens the form it restricts to only his/her record and team players. I have a function that reads the computer logon ID of the managers, where would I invoke this function?

    Thanks Darren.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Restrict View (2000)

    Set the record source of the main form to a query that selects the record of the logged in manager. To do this, include a login_name field in the table, and set the criteria for this field in the query to the function that retrieves the login name.

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Restrict View (2000)

    Thanks Hans.

    Darren.

Posting Permissions

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