Ask Your Question

How to search Form AND Subform in Base

asked 2016-10-04 17:15:50 +0200

RRay gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-11-24 08:33:45 +0200

jay Arr gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-10-04 17:15:50 +0200

Seen: 276 times

Last updated: Nov 24 '16