Use an existing form as a template for others

[Guest]

I have created a simple db to track outbound calls made by our outbound
department. Is there a way that I can take an existing form and use it with
other queries?

 

[tina]

you can change the RecordSource of a form at runtime. if the fields in the
different record sources have different names, you'll also have to set the
ControlSource properties of the controls at runtime.

hth

 

[Guest]

I am no expert but I do this all the time. There are many ways, but this
works just fine.........

Open "outbound form" in design view. Do File/SaveAs and give form new name
like "inbound form". This creates new form. In design view, open form's
properties and change the Control Source to the new query or table. Also, you
may have to change the Control Source of the new form's fields to match the
new query fields if the names are different.