Using the same format for all Forms within 1 database

[dplove]

I have created a Form from a table. The form is formatted the way I would
like. I have several other tables that I would like to change to Forms but I
would like to use the same format from the 1st Form without having to
manually format it. Is there a way to use this format for all of the Forms I
create?

 

[KARL DEWEY]

Open the form in design view, click on menu FILE - Save As and save as your
new form name. Then edit the Record Source to the other query.

 

[dplove]

Thank you, thats what I was looking for

Open the form in design view, click on menu FILE - Save As and save as your
new form name. Then edit the Record Source to the other query.

 

[tedmi]

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.

 

[KARL DEWEY]

If the data source has differering field names then the queries would need to
have generic alises like Field1, Field2, etc.

 

[Klatuu]

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.