Results 1 to 4 of 4
  1. #1
    JeRz is offline Advanced Beginner
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2014
    Posts
    33

    Passing data from form to form

    Hi All,



    i have used OpenArgs in the past to achieve what I am looking to do but I am having an issue this time around.

    I have an Issues form which includes a button to add a new note. A new form appears to add the text needed. This saves to a Notes table. I have a one to many relationship from the Issues table to the Notes table. In the Issues table, the IssueID is the PK and is an autonumber. I have IssueID also in the Notes table as the FK.

    The issue I am having is I need to pass the IssueID from the New Issue Entry form to the New Note Entry form. Since these fields are numbers, is there a way to achieve this?

    Thanks!

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    This is flagged as solved; is it not? OpenArgs should work. You could also open the form and then populate a control with the value.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    JeRz is offline Advanced Beginner
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2014
    Posts
    33
    Thanks! Yes, I forgot I submit my follow up reply. Oops. Everything works with OpenArgs. Just had to make a minor tweak I was missing

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No worries, glad you got it working.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Passing data from one FORM to another FORM
    By sud2017 in forum Forms
    Replies: 31
    Last Post: 07-31-2017, 09:25 PM
  2. Passing Data From One Form to Another
    By CharlieK in forum Access
    Replies: 19
    Last Post: 10-31-2016, 07:48 PM
  3. Passing Data From One Form to Another Form
    By ETCallHome in forum Forms
    Replies: 6
    Last Post: 03-12-2011, 12:53 PM
  4. Passing Data from on Form to Another..
    By ETCallHome in forum Forms
    Replies: 2
    Last Post: 03-12-2011, 12:26 AM
  5. Form not passing data to query
    By bobfin in forum Queries
    Replies: 13
    Last Post: 08-11-2010, 05:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums