Copying records(duplicating records)

[zandiT]

hello
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

[Delerna]

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.

[zandiT]

helo
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