copy record in a subform

Discussion in 'Microsoft Access Forms' started by Guest, Nov 20, 2007.

  1. Guest

    Guest Guest

    Is it possible to copy a record in a subform? I want to have all field values
    except one (or maybe 2) be the same.

    Thanks.

    Karen
     
    Guest, Nov 20, 2007
    #1
    1. Advertisements

  2. Guest

    Allen Browne Guest

    See:
    Assign default values from the last record
    at:
    http://allenbrowne.com/ser-24.html

    The article explains how to have a form automatically add the same data you
    had in the last record, as soon as you start entering a new one.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Karen" <> wrote in message
    news:...
    > Is it possible to copy a record in a subform? I want to have all field
    > values
    > except one (or maybe 2) be the same.
    >
    > Thanks.
    >
    > Karen
     
    Allen Browne, Nov 20, 2007
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Greg
    Replies:
    0
    Views:
    809
  2. Guest
    Replies:
    0
    Views:
    176
    Guest
    Apr 8, 2005
  3. Nigel Greenwood via AccessMonster.com

    Subform, new record, Focus goes to last field on next subform entry

    Nigel Greenwood via AccessMonster.com, May 7, 2005, in forum: Microsoft Access Forms
    Replies:
    1
    Views:
    471
    Alex White MCDBA MCSE
    May 7, 2005
  4. Mikal
    Replies:
    2
    Views:
    530
    Mikal
    May 25, 2006
  5. Cy
    Replies:
    3
    Views:
    383
    Jeanette Cunningham
    May 7, 2008
Loading...

Share This Page