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

  • Thread starter Thread starter forest8
  • Start date Start date
F

forest8

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
 
Back
Top