Results 1 to 4 of 4
  1. #1
    mikael is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    24

    search a subform field from a Search tab on the main form


    i have 1 main form (USER) and 3 subform ( ASSET, INVOICE, LO) which related together.. i need to create search button in a main form that only can search ASSET_ID... it means find the record through subform.. how can i do that? can anyone pls help me.. thank you

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,682
    Since the subform records are limited to those that are related to the current USER, those are the only ASSET_IDs that can be searched for and displayed. Can't you already see all the related ASSET_ID records on the subform?

    What is it you are really trying to accomplish?
    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
    mikael is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    24
    what i need is to create a search form.. currently, i already have a textbox with a listbox. user enter the assetid and the listbox highlight the related record. i wish i could display the record when user double click from the listbox.. how can i do that?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,682
    Here is one method that might help you 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.

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

Similar Threads

  1. Search Main Form Based on Contents in Subform
    By MintChipMadness in forum Forms
    Replies: 1
    Last Post: 08-09-2012, 02:45 PM
  2. Replies: 7
    Last Post: 08-08-2012, 03:28 PM
  3. Replies: 4
    Last Post: 07-11-2012, 10:31 AM
  4. Replies: 13
    Last Post: 01-29-2012, 01:45 PM
  5. Replies: 2
    Last Post: 08-31-2010, 08:57 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
  •  
Tech Forums: Microsoft Office Forums