If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Access > Copy Form Record with Multiple Sub-Forms

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: May 2012
Location: Boynton Beach, Florida
Posts: 7
Copy Form Record with Multiple Sub-Forms

Can someone help me, I have an access form with multiple sub-forms on it that saves in multiple tables. A person goes in this form and enters all the information on a specific job, unfortunately many times the same information may be put in multiple times. Same client, same address, etc. We would love to be able to have a command button that would copy an existing record and create it with a new ID (basically a copy and paste) and then we can go in and just change the items that need to change. (VBA) Right now the data goes to a Property table, Invoice table, Client table, etc. and there is a sub-form for each of these. Thank you for your help.
Reply With Quote
  #2 (permalink)  
Old
Moderator
 
Join Date: Jun 2005
Location: Richmond, Virginia USA
Posts: 2,485
As is often the case, Allen Browne has a hack for that:

Microsoft Access tips: Duplicate the record in form and subform

Linq ;0)>
__________________
Hope this helps!

The Devil's in the Details!!

All posts/responses based on Access 2003/2007
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: May 2012
Location: Boynton Beach, Florida
Posts: 7
Thank you so much! This has been a dilemma in our office for a very long time.
Reply With Quote
  #4 (permalink)  
Old
Moderator
 
Join Date: Jun 2005
Location: Richmond, Virginia USA
Posts: 2,485
Here's the link to Allen's main page.

Microsoft Access help, tutorials, examples

His coverage is so extensive and comprehensive that many of the articles have been used by Access in the MSDN! It's always my first stop when I'm looking for a solution to an Access problem and his solutions are always spot on!

Linq ;0)>
__________________
Hope this helps!

The Devil's in the Details!!

All posts/responses based on Access 2003/2007
Reply With Quote
Reply

Tags
copy records

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On