470,585 Members | 2,044 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,585 developers. It's quick & easy.

How do I "Copy" and "Paste" child subform records in details section?

Hello. I am new to access, but have had great success in creating an application. My one user is requesting a function to save time in data entry... and I am stumped being the plebian that I am.

My application is used to enter land owner information by parcel (40 acre lots). For example: for parcel #1 someone owns the land, someone owns the mineral rights, someone owns the water rights, etc, etc... and we inventory about 36 square miles of land (about 600 parcels) for now.

My master on the form is the Parcel ID, and the child subforms are the different categories of ownership (surface, mineral, etc) sorted by their legal descriptions (Parcel ID - which includes Township, Range, Section, QQ).

I want to create a function that works like copying something to the clipboard, but I would be "copying" the current records in the subforms so I could "paste" them into a different Parcel ID record.

Here is my question:
How can I copy all the records on a subform (using a click event), find a different record (parcel), and then "paste" them into the same subforms (using a click event)?

Keep in mind I will need new auto numbers.

Do I store them as a variable? Use an append query? If someone could start me off on the right foot, I would be grateful. If you need more details I will provide.

Oct 2 '07 #1
1 2113
3,080 Expert 2GB
Copying data isn;t the way to go in a normalized database.
You should identify the "corresponding" fields and create another table with an autonumber ID for them.
You can see the Northwind.mdb as a sample. Not every order will hold the Customer Address information, there's a tblCustomer and there's the address. The order just holds the CustomerID.

The same way you need to rethink your tables.

Getting the idea?

Oct 6 '07 #2

Post your reply

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

Similar topics

2 posts views Thread by Eric Sabine | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.