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.