Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    87

    Unanswered: Duplicate whole record (in form)

    I have a form (with subform in it) and i fill it with different values. After some time, i need to fill another record (new one), with similar values.Is it possible to make a duplicate of my previous record, and put it in the "new record" so that i won't have to fill all fields again, only change excisting ones to different values.

    Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    cut & paste should do the trick

    select the left hand side of the form
    ctl & C
    add a blank record
    ctl & ins

    you could do it differently (by using a vba function to copy the current record and then add new etc...), but C&P is by far the easiest to implement

Posting Permissions

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