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

record template

P: n/a
vmg
Hello All

I'm using Access 2K and Access 2003 with either Win2K or XP.
A database for control plans exists. But one customer would like
a button or hotkey to copy a given record, then paste all the data
into a new record. The record number would be new, and the customer
would make changes to one or two fields to finish the new record. There
are approximately 100 fields and two subforms in this database. This
would save a lot of time entering new records that are very similar.

Is there an easy way to do this?

Thank You for any help
vince
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
create a query that points to the current record.

SELECT....
FROM ....
WHERE RecordID = Forms![FormTheButtonIsOn]![PrimaryKeyOnForm]

Then turn it into an insert query so it appends to the same table. And
remove the Primary key field from the insert statement.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.