How to get Check Box to apply to Keyword Text Box?

[vha7]

Hi all,



Access newbie here

I have a database/form that contains a list of papers on drug information, with columns such as Indication, Patient Population, Study type, Category, etc.. I have a Category Combo Box that allows me to choose the type of "drug category" it is and a text box to enter a keyword and a search button to search the key word that is contained within any of the columns mentioned above AND also search within the category combo box (they are linked). However, I want to add check boxes that will allow me to be more specific with what my keyword search searches up such that I click the box of choice, and that would be linked and apply to the search box AND/OR combo box so it would further specify my form results. Notably, I want the checkboxes to be able to search any column that is exactly or contains (using wildcard LIKE) the name of the check box (i.e Drug A, Drug B, ..., and/or etc)

Below, Drug B and D check boxes are checked off in which I will search within those two.


Any help would deeply be appreciated.

Thanks

[ranman256]

The drug name would be in a single column: [DRUG name].
why would you want to search other columns for this drug name?

you could have the tDrug table have the fields:
DRUG NAME
mark

then the query would join the tDrug.DrugName to tDatatable.DrugName where tDrug.Mark = true.
but this wouldnt work well in a multi-user environment.
Is this the case?

[vha7]

The drug name would be in a single column: [DRUG name].
why would you want to search other columns for this drug name?

I want the check box to search other columns because I don't have a column for the "Drug Name" specifically, I would have to manually create the column and fill it out on my own (I know my data is weird), but lets say the other columns contain the respective "Drug Name", thus, I would like to have it search across all the fields.

And could you explain the query portion? Sorry

I have also included an image of what my form looks like above