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:
    1,018
  2. Guest
    Replies:
    0
    Views:
    246
    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:
    612
    Alex White MCDBA MCSE
    May 7, 2005
  4. Colin Possamai

    Code new record in subform from outside of subform

    Colin Possamai, Feb 18, 2006, in forum: Microsoft Access Forms
    Replies:
    2
    Views:
    244
  5. Mikal
    Replies:
    2
    Views:
    777
    Mikal
    May 25, 2006
  6. Guest

    Record count of a subform in another subform

    Guest, Aug 11, 2006, in forum: Microsoft Access Forms
    Replies:
    1
    Views:
    272
    strive4peace
    Aug 11, 2006
  7. carriey

    Subform to select record for subform

    carriey, May 5, 2008, in forum: Microsoft Access Forms
    Replies:
    0
    Views:
    238
    carriey
    May 5, 2008
  8. Cy
    Replies:
    3
    Views:
    494
    Jeanette Cunningham
    May 7, 2008
Loading...