Results 1 to 2 of 2
  1. #1
    vha7 is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Jul 2018
    Posts
    46

    How to connect Checkboxes (using LIKE operator instead of Yes/No) to Search Keyword


    I have a form right now that has a combo box and search keyword text box that will allow me to search any keyword within any type of publication/paper.
    i.e I choose the combo box first (category of paper) then within the category, it narrows it down to my keyword that I type in.

    NOTE: Is it possible for me to create the checkboxes that are not applicable to the columns of the results/source file/excel sheet I am using, but instead, create them so that they are keywords that are found within any of the columns while using LIKE to locate them?
    i.e create checkboxes such that they are the diseases found across any field/column, I.e "cancer" "respiratory", "Digestive", "Nervous System", etc rather than the checkbox label be "Disease"
    i.e
    x Cancer
    x Respiratory
    x Digestive
    x Nervous system

    instead of:
    x Disease
    x Column 2
    x Column 3
    ...
    ...
    etc

    My goal is that I want to add a checkbox option where it narrows the search even further:
    1)Chcking off the checkboxes first, which filter out the papers with the desired terms, then further choose the category in my combo box that's within only those checked boxes, which then further I can search my keyword.
    2) Just apply the checkboxes to my keyword search so that only the checked boxes provide the filter for what I am able to search the key word in.
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    your tables are not designed correctly for searching.
    queries search in a column (ie, Subject), not across columns.
    the tSubject table would be a sub-table to the Master table:
    [ParentID], [Subject]
    1, cancer
    1, digestive
    2, Nervous

    tSource table:
    ID, Author
    1, Lichtenstein GR
    2, Ungar B

    to search subjects in 1 column: Subjects.

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

Similar Threads

  1. Keyword Search from Subform
    By jdowning in forum Forms
    Replies: 5
    Last Post: 05-20-2016, 07:47 AM
  2. keyword search
    By Mbakker71 in forum Access
    Replies: 5
    Last Post: 02-05-2014, 06:03 AM
  3. A TRUE Keyword Search
    By Meep in forum Queries
    Replies: 72
    Last Post: 05-13-2013, 06: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

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