Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Mar 2001
    Location
    Bismarck, ND, USA
    Posts
    451
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Duplicate Form Fields on Demand (2002 sp2)

    I have a user form to record order information. It was designed for one item per form. Is there an easy way <img src=/S/exclamation.gif border=0 alt=exclamation width=15 height=15> to duplicate the group of fields (Qty, Item #, Description) on demand--so the user could repeat the data entry for a second item on the same form?
    egghead

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts

    Re: Duplicate Form Fields on Demand (2002 sp2)

    You would need to use a macro to do this. The user could possibly fire it by checking a check box (eg Add new Item).

    The code for the macro would depend on the form layout and the names of the fields. It would also have to include emptying the fresh fields.

    If you need help on the code, post the form.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  3. #3
    4 Star Lounger
    Join Date
    Mar 2001
    Location
    Bismarck, ND, USA
    Posts
    451
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Duplicate Form Fields on Demand (2002 sp2)

    Sounds like it may be more complcated then I want to deal with, but . . .

    The fields that need to be duplicated is Qty, Item #, Tag, Description and Finishes.
    Attached Files Attached Files
    egghead

  4. #4
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts

    Re: Duplicate Form Fields on Demand (2002 sp2)

    Attached is a clunky demonstration of what I meant.

    If you want to add an item, click the new checkbox and then press Tab
    Attached Files Attached Files
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  5. #5
    4 Star Lounger
    Join Date
    Mar 2001
    Location
    Bismarck, ND, USA
    Posts
    451
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Duplicate Form Fields on Demand (2002 sp2)

    That looks like it will work nicely! Thank you! <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>
    egghead

Posting Permissions

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