Have you considered creating a tab control in your main form? It could have
7 tabs and a subform in each one corresponding to the data in the main table.
It's clean and easy to implement but might be slow.

cs_vision wrote:
Thanks for your help, I didn't realize this is not what I needed, how do you
remove the subdatasheet?

To explain better, I am trying to create a form from 8 tables. The main
table called documents has client name, attorney, documents, document date
and classification fields. The remaining 7 tables are child tables bound by
the classification field (or so I want them to be). Based on the
classification choosen for each client name, I would like the form I created
for the remaining 7 tables to popup. Each table/form represents a certain
classification.

I have a table that I have added fields that contain lookups to other tables.
How can I display the full table from that field within the main table?

--
Message posted via http://www.accessmonster.com