Access 2010-Beginner 2- Forms: Following your directions I've created a form I love, is there a way to copy and paste the form design to use for a different table?

---

Reply from Richard Rost:

Sure. If all of your fields are named the same, you can just copy and paste the form itself (click on it in the Navigation Pane, press Ctrl-C to copy, then Ctrl-V to paste it). Open it up in Design View, then open the Property Sheet (Design Tab > Tools Section > Property Sheet). On the Data Tab, find the RECORD SOURCE property (on the top). Change that to the other table. If any of the fields are named differently, you have to change the CONTROL SOURCE property of those fields to match. That's all you have to do. We'll spend more time with form properties in upcoming classes.