Results 1 to 6 of 6
  1. #1
    jdowning is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    May 2016
    Posts
    3

    Keyword Search from Subform

    Hi,

    I have a subform within a form pulling all the right data on employees using a keyword search and combo box by title.

    How can I have the form display no records in the subform until I search?



    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    turn the subform off,
    me.subform.sourceobject = ""

    then reconnect to the form
    me.subform.sourceobject = "frmMySubForm"

  3. #3
    jdowning is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    May 2016
    Posts
    3
    Click image for larger version. 

Name:	sfm.JPG 
Views:	12 
Size:	80.0 KB 
ID:	24660 Where should I insert that code?

  4. #4
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    The 1st line on combo7-click()
    but is does no good to turn off the form to reset the SQL.
    you must keep both active.

  5. #5
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Just make the subForm invisible, then set the SQL.

  6. #6
    jdowning is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    May 2016
    Posts
    3
    Thanks you!

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

Similar Threads

  1. 2 Field Keyword Search
    By Emma35 in forum Forms
    Replies: 11
    Last Post: 01-19-2016, 08:34 AM
  2. keyword search
    By Mbakker71 in forum Access
    Replies: 5
    Last Post: 02-05-2014, 06:03 AM
  3. keyword search in a combo box
    By pbouk in forum Forms
    Replies: 9
    Last Post: 05-30-2013, 09:45 PM
  4. Multiple Keyword Search
    By gatsby in forum Access
    Replies: 15
    Last Post: 01-21-2013, 10:53 PM
  5. Making a keyword search
    By timmy in forum Forms
    Replies: 9
    Last Post: 03-14-2011, 02:57 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