Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2009

    Unanswered: A Difficult One...(I Think)

    Hello Everyone,

    OKay, i have a slight task that i need to complete and i dont have enough knowledge of access to put it off.

    As it stands, i have a login dialog form, which uses a table containing member details, where the users select their name, and click "login".

    That works fine, and when the user clicks "Login" the form "Login Home" is opened. The Login Home form has the users Account Information In there.

    I need to know how i can do the following:

    I need to some how "jump" to the same record as was chosen when the user logged in.

    If the user chooses "Derek Jones" and clicks login, i need Derek Jones's record to be displayed when the Login Home form is opened.

    Thanks in advance,

    I am able to upload my database if you need it.

  2. #2
    Join Date
    Apr 2004
    metro Detroit
    You don't want to jump to the record, you want to "filter" for the record. An easy way to do that is by adding the filter criteria to the openform command. Look up openform in Access help for details.

  3. #3
    Join Date
    Nov 2007
    Adelaide, South Australia
    Or you could change the "Login Home" form's Record Source SQL to include a WHERE clause that restricts it to only that user. That would be better if you don't want users to hit "Remove Filter" to get to everyone again.

    You'd have to do it with your Login button's code.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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