That creates a potential maintenance nightmare, if you want the forms to be
identical forever, because you would have to apply any changes to multiple
forms (one of the few certainties of app design is that the design will
change!)
A better approach is to use a single form, just change the data source at
each use. You could create a menu form that lists all of the data sources,
clicking on one of them would open your data form and set its data source
property in the Open event. That way, you would have only two forms to
maintain: one data form, plus the menu form if the number of data sources
changes.

Signature
TedMi
> Thank you, thats what I was looking for
>
[quoted text clipped - 6 lines]
> > > manually format it. Is there a way to use this format for all of the Forms I
> > > create?
KARL DEWEY - 22 Feb 2008 16:15 GMT
If the data source has differering field names then the queries would need to
have generic alises like Field1, Field2, etc.

Signature
KARL DEWEY
Build a little - Test a little
> That creates a potential maintenance nightmare, if you want the forms to be
> identical forever, because you would have to apply any changes to multiple
[quoted text clipped - 17 lines]
> > > > manually format it. Is there a way to use this format for all of the Forms I
> > > > create?
Klatuu - 22 Feb 2008 18:45 GMT
Not a good idea.
Karl's suggestion is a good one. It is not that every form will be the same
forever, but this is only for getting the app up and running quickly. I do
the same thing myself.

Signature
Dave Hargis, Microsoft Access MVP
> That creates a potential maintenance nightmare, if you want the forms to be
> identical forever, because you would have to apply any changes to multiple
[quoted text clipped - 17 lines]
> > > > manually format it. Is there a way to use this format for all of the Forms I
> > > > create?