Command button help

[anastam]

Hello!



I created a command button for my form to easily search for words throughout my multiples records. I have an additional subform/report on my form that tracks keywords per project. The word search button that I input won't search for words in the subform. Is it possible to have the word search command button search for words in each form, as well as the keyword subform I have?



Thanks!

[ranman256]

Normally, you don't search words in a form. Do you mean search words in the data on the form?
Or searching using the keyword typed in a box on the form?

But above you seem to be entering keywords into a table. (ON A FORM)
you would just run a query joining the above table to the data table.

BUT
if you want to search the word given , INSIDE a string in a field, then that's a different set of queries Id have to think on.
(anyone?)

[anastam]

So on the form, we have fields for project name, year, business, etc. And for each project, we have a subform that contains keywords specific to that project. What we are looking to do is be able to search all the records (currently 41 records) for words either on the form OR within the subform. For instance, I want to search for projects that have year "2013" or that have keyword "completed." Hopefully that provides some clarification.

I do have tables and queries set up, but we are using this form sheet as our main "dashboard" and were hoping to be able to do everything without leaving the form.

Thanks!

[ranman256]

a little tougher.
then you must know what field to search the keyword.
so
[keyword], [field]
completed, Status
2015, [proj year]

for all the work that would go into this,
you might as well make a form with all the fields names, and boxes for user to enter the keyword.