Find Command in Access

[megan1989]

I am hoping that the answer to this will be yes, but I have a sneaking feeling that it is No. Is there a way to use the find command in access in one report to search throughout the whole database. For instance, I am designing a database that in a report it shows the number identifier of an item, and the actual detailed information is located in a separate form. What I want it to do is to be able to find the detailed information from a command within the report that only has the number identifier. Thanks

[June7]

You want to search for data across all tables and queries? No, cannot do that.

Can have a DLookup() expression in a textbox to pull data from another table/query.

Maybe you just need to build a query that includes the necessary tables for the report RecordSource.

Maybe you need to build report/subreport arrangement.

[megan1989]

Thank you June, I've done a little work with what you suggested and it looks like that will work