Results 1 to 3 of 3
  1. #1
    smahdih is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    52

    Search in a table and display subform

    hi
    i have many field in a table and create a form by fields table, instance below fields:
    id
    FirstName
    LastName


    i want have a combobox in form and type a id in combobox and then disply respective FirstName and LastName in my form like subform

    How do it?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,603
    You want to select item from UNBOUND combobox row source and filter a form to display record for that selected item? Maybe this is what you want http://datapigtechnologies.com/flash...tomfilter.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    smahdih is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    52
    very very tnx ...
    god bless you

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

Similar Threads

  1. Search in subform
    By Wayne311 in forum Forms
    Replies: 1
    Last Post: 03-06-2013, 06:09 AM
  2. Query search wont display null fields
    By Coffee in forum Queries
    Replies: 2
    Last Post: 08-08-2011, 09:00 AM
  3. Replies: 1
    Last Post: 07-21-2011, 01:57 PM
  4. Display Fields in Search Form
    By j2curtis64 in forum Forms
    Replies: 1
    Last Post: 07-18-2011, 01:37 PM
  5. Replies: 1
    Last Post: 04-01-2011, 01:28 PM

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