Results 1 to 2 of 2
  1. #1
    Join Date
    May 2013

    Unanswered: Using info from 1 form to another but not linked to the same table.

    I have two forms each linked to their own table.

    Form 1 has 6 fields 2 of which appear in form 2. Form 2 has these 2 fields and 3 of it's own.

    When you go from form 1 into form 2 clicking the button I would like it to look and see if there is already a record for this in Table 2 and display this so you can edit the information.

    If there isn't already a record I want it to go to a new record but fill in the 2 fields from form 1 so you only have to fill in the additional details.

    What sort of code would I use to achieve this?

  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 18
    Depends how you go from form 1 to form 2. If you use DoCmd.OpenForm, you can use the shared values as the OpenArgs argument, and then pick them up in form 2's Open event.
    Have a look in the Help file and have a play.
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Posting Permissions

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