Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Feb 2004
    Kitchener, Ontario, Canada
    Thanked 0 Times in 0 Posts

    loging a user (xp)

    I have a login screen made to only let people who are users in the database access to run the database... this is not for security but for keeping people out from making changes if they are not given permission. What I want to do is take the user name that they select in the pull down box on the form and make this the criteria for the query until they logout This query will be the switches to let different parts of the database know if this person has rights to do things in different areas.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: loging a user (xp)

    The bound column of the combo box corresponds to UserID, not to LoginName. So you should place the condition [Forms]![Password screen]![cboEmployee] in the UserID column in the query.

Posting Permissions

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