Want to Unify different Reports/Queries

  • Thread starter Thread starter dohernan
  • Start date Start date
D

dohernan

In Access 2003 I have a huge table, PersonnelStats, and a Form to
input/update Records into it.

I have another Form that asks you for a Start Date and End Date then tells
you how many different Form types were completed in that period, based on the
above Table.

Then I have a 3rd Query that checks to see what forms are currently Not
completed.

I would like to create 1 Form, or Page or something that holds the above 3
as options so folks don't have to hop around, something I can easily send
them a Shortcut or Link to.

Thanks. :)
 
Here is how I would do it. First, I would create a tab control with a page
for each of your current forms. Then on each of those pages I would put a
subform control. Now identify you current forms as the source objects for
your subform controls. It will load a bit slower than your individual forms,
but once open, navigation from page to page is very fast.
 
Back
Top