Create a copy of a form and link the entire form to a new datasour

Hi

I have two surveys: the initial survey and a post survey.

The Post survey includes all the questions in the initial survey as well as
new questions.

I want to save time in creating forms. How can I make a copy of the initial
survey form and call it "Post" and add my new questions but change the source
to my "Post" table without recreating the entire form?

Thank you in advance.

You change the recordsource of the second form. You can use a single form
and change the recordsource on the fly. Just add a button to the form to
change the recordsource, like:

Sub cmdChangeSource_Click()
If Me.Recordsource = "Query1" Then
Me.Recordsource = "Query2"
Else
Me.Recordsource = "Query1"
End If
End Sub
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"forest8" wrote in message
...
Hi

I have two surveys: the initial survey and a post survey.

The Post survey includes all the questions in the initial survey as well
as
new questions.

I want to save time in creating forms. How can I make a copy of the
initial
survey form and call it "Post" and add my new questions but change the
source
to my "Post" table without recreating the entire form?

Thank you in advance.