-----Original Message-----
is it possible to search an entire database from a form
which is used to open other forms containing the data
It depends on several things. If there are relatively few
tables in your db, and one or more of them are linked in
some way to whatever your form is based on, then you can
use Dlookup on each table to locate the information that
you want. This would require that you either know the
names of the tables or that you know how to get access to
tell you the names of the tables.
If there are a lot of tables to search through, it may not
be worth trying, create a separate query instead.
If there is nothing to link your form to one or more of
the tables then you can't search it, you would have to
force a link of some kind (either a separate query, or a
new table that combines info from several others).
