Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008

    Unanswered: Do I need a Control Source?

    I have a drop down list of Last name and first name.

    I want this to be the only unlocked feature on the page. When a name is selected the other information is shown (the persons cc#, Exp date, phone number, email etc.)

    I am almost sure its a control source, but i'm not 100% as i'm relatively new to Access..

    Another issue I would like to know is how to show the Last Name, First Name in the selected drop down after its selected, currently its only showing the Last name.

    Thanks in advance

  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    Isn't this the same question as your other topic?

    If you want Firstname and Lastname to appear in the combo box, then you will have to create a concatenated column in the Row Source SQL for it
    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