By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,551 Members | 2,741 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,551 IT Pros & Developers. It's quick & easy.

Copying records(duplicating records)

P: 48
i created a database that has a form which represents a template. this template is filled out every month. my problem is i don't want to have to copy and paste ever record wen the template is being filled out the next month. i thought of putting the controls i want to duplicate in a label, but the text is too much and i can't scroll with a label control, so had to use a text/ memo box. is there a way i can click a button and the records are duplicated on a fresh form so users can fill it out? i could copy and paste, but that would take far too long
thanks guys
Nov 20 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,134
Is the template in its own table?
If so you could link the button to an append query.
The append query would insert the record in the template into your table ready for the user to fill out.

Alternatively, you could write some VBA code to do a similar thing when the button is clicked.
Nov 20 '08 #2

P: 48
thankyou for the reply. yes its in its own table. ive never done an append query, but let me do some research on it and try it out
thanks again
Nov 20 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.