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.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 2.