Results 1 to 4 of 4
  1. #1
    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.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,536
    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

  3. #3
    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.

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,536
    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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •