can we change the table to which a form is bound?

[ariansman]

I have made and designed a form on a table. I want to make another form totally like this one to be bound to another table. Can I make a copy of the current form and change the table to which it is bound? This way I will save a lot of time to design a new form.

 

[Galaxiom]

That is easily done by changing the RecordSource property of the form.

However this requirement suggests that the two tables really should be the same table with another field added to designate the attribute that you are currently using separate the records into two tables.