I’ve created a form with a subform. When I search, I can only search either the Main Form OR the Sub Form. Is there anyway to have a general search that finds ANYTHING in the database?
i.e. When I search, I’d like the appropriate form entry to be displayed, whether the result is in the main form or subform.
I think you are misunderstanding the function and capabilities of searching a database.
See here for more information.
Put simply you can search a table for a row (or rows) by specifying a criterion (or criteria) for a field (or fields).
You can search multiple tables (i.e. all tables in your database) by using a macro that would loop through all your tables using SQL specific to each table, specific to each field in each of the tables. e.g. looking for the value one requires different SQL if the field to be searched is an integer, text or date.