Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Jul 2003
    Location
    Duluth, Minnesota, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Avoid repeat data entry between forms (XP)

    I have two separate Word forms in which after entering data in the first form some of the same data is needed when I fill in the second form. Is there any way to link the fields to update from

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Avoid repeat data entry between forms (XP)

    Are they separate documents, or two forms within one document?

  3. #3
    New Lounger
    Join Date
    Jul 2003
    Location
    Duluth, Minnesota, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Avoid repeat data entry between forms (XP)

    They are two separate documents.
    DD

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Avoid repeat data entry between forms (XP)

    Would it be feasible to combine them into one document? It would then be fairly easy to fill in items in the second form based on the entries in the first one.

  5. #5
    New Lounger
    Join Date
    Jul 2003
    Location
    Duluth, Minnesota, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Avoid repeat data entry between forms (XP)

    Hmmm, yes, I think if it would make it easy to link the fields we could combine them.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Avoid repeat data entry between forms (XP)

    You can do it like this:
    - Unlock the combined document.
    - Double click a form field in the first form whose value you need in the second one.
    - Note the bookmark name of the form field, say Text3. You can change it to a more meaningful name if you wish.
    - Tick the check box "Calculate on exit".
    - Click OK.
    - Move to the form field in the second form you want to fill.
    - Double click this form field.
    - Set the Type to Calculation
    - Set the Expression to =Text3, with the appropriate bookmark name substituted.
    - Click OK.
    - Repeat as needed.
    - Finally, lock the document for forms again.

  7. #7
    New Lounger
    Join Date
    Jul 2003
    Location
    Duluth, Minnesota, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Avoid repeat data entry between forms (XP)

    Thank you Hans!

Posting Permissions

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