Results 1 to 2 of 2
  1. #1
    dalton is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    May 2010
    Posts
    11

    Linking Forms

    Hello, I currently have two forms. One has a list box with peoples names. I've got a double click event to open another form where I've got additional info on this person. It works, but always opens on the first person I put in the database, regardless of whose name I clicked on. I realize it probably has to be bound in some way, but I don't know the easiest way. I'm a beginner at access, so thanks for the help. I also have another problem with clicking on the persons name and having their phone numbers display in two text boxes below. I've got it displaying, but there is a new problem. If you think you can help, then click on my name and find the thread. Thanks a lot.



    Also, I've set it to open, how do you hide the main form and display the second from until you say, click a button called "return to main form".

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Sounds like you want something like this:

    http://www.baldyweb.com/wherecondition.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Linking Table Data on Forms
    By P5C768 in forum Database Design
    Replies: 12
    Last Post: 03-22-2010, 09:42 AM
  2. linking forms by ID - automatically add ID
    By jlcaviglia-harris in forum Forms
    Replies: 0
    Last Post: 04-17-2009, 03:51 PM
  3. Resource for using linking tables with forms?
    By narayanis in forum Forms
    Replies: 5
    Last Post: 05-18-2008, 04:11 PM
  4. Linking tables and forms
    By vgatell in forum Access
    Replies: 0
    Last Post: 02-10-2007, 01:37 PM
  5. Replies: 2
    Last Post: 09-14-2006, 04:12 AM

Tags for this Thread

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