Results 1 to 4 of 4
  1. #1
    andy21 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2014
    Posts
    1

    Drop down list

    Hello everybody!
    I have a little problem here.
    I am trying to make a form with one drop down list (Name for example) and a few other fields (phone,email,etc), all which I want to import from one table.
    My actual problem which I do not know how to do is the fact that when I change the Object from the list (Name) I want the other fields to adjust themselves to the info (phone,email,etc) of the new one, how do I do this?
    I know this might sound really strange or not make too much sense, but help would be appreciated.


    Thank you

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,610
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    528
    andy21
    use a subform and of a one - many relationship

  4. #4
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    528
    https://www.accessforums.net/database-design/multiple-one-many-relationships-26101.html

    Search the Forum
    Don't post your question in the forums
    Here you will find many people of good teachers



Please reply to this thread with any new information or opinions.

Similar Threads

  1. Help with drop down list
    By Wlbyfred in forum Forms
    Replies: 5
    Last Post: 05-21-2013, 10:54 AM
  2. Drop Down List
    By haazzaa in forum Forms
    Replies: 3
    Last Post: 03-19-2012, 05:17 PM
  3. drop down list
    By slimjen in forum Access
    Replies: 6
    Last Post: 09-15-2011, 01:43 PM
  4. Replies: 4
    Last Post: 06-16-2011, 09:30 PM
  5. drop down list
    By tceicher in forum Access
    Replies: 5
    Last Post: 08-13-2009, 05:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums