Results 1 to 4 of 4
  1. #1
    vCallNSPF is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Dec 2009
    Posts
    49

    Search function to select table record in form

    Hi,
    Ive got a table of pager information in my database, each pager has its own unique ID followed by other fields such as, who owns the pager, frequency, the model etc...



    i have a form that i use to edit and add pagers to my database (obviously)

    ive got a combo box on the form that is connected to the ID field of the pager information table, how do i select an ID from that combo box and have the information from the related record appear in my form.

    thanks

  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,521
    Try using the combo box wizard, choosing the third option, "Find a record...".
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    vCallNSPF is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Dec 2009
    Posts
    49
    i went through the entire combo box wizard, there is no "Find a Record..." option.

  4. #4
    vCallNSPF is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Dec 2009
    Posts
    49
    Thankyou 'F1'

    solved.

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

Similar Threads

  1. 2 multi select list boxes on one search form
    By woodey2002 in forum Forms
    Replies: 2
    Last Post: 11-05-2010, 12:44 PM
  2. Replies: 3
    Last Post: 01-14-2010, 08:32 AM
  3. Replies: 1
    Last Post: 02-25-2009, 07:29 PM
  4. Replies: 0
    Last Post: 10-16-2008, 02:39 PM
  5. Search for record from a form
    By hcoakley in forum Forms
    Replies: 0
    Last Post: 11-26-2006, 11:23 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