Results 1 to 5 of 5
  1. #1
    jpkeller55 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Sep 2010
    Posts
    169

    Pass value from an unbound object on one form to another form that is already open

    I am sure this is possible but not sure how to go about this. I have a form that has a memo field with values in a particular format. For example: 11111-2222-33; 44444-5555-00 etc... This memo field could contain one or many values. I have a pop-up window that displays when a user double clicks this memo field that provides an input field that has an input mask of AAAAA\-AAAA\-AA;0; so the user will enter the values in the correct format. On this pop-up form, I have an unbound field that caputures the the entries. I would like for the values captured in this unbound field to be copied to the original memo field in the open form.



    The original open form is: frmQuestionDetail
    the field name is: NDC

    the popup form is: frmNDCentry
    and the field is: NDCupdate

    So essentially, I am trying to copy the value from NDCupdate from frmNDCentry to the NDC field in the open form frmQuestionDetail.

    Thanks for any help.

  2. #2
    jpkeller55 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Sep 2010
    Posts
    169
    Figured this out...thanks anyway.

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Basically

    DestinationReference = SourceReference

    with the appropriate form references:

    Forms Refer to Form and Subform properties and controls

    If you want to add to the existing data in the destination, this type of thing:

    DestinationReference = DestinationReference & " " & SourceReference
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  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,521
    Looks.....like......I.....type.....too.....slowly.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    jpkeller55 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Sep 2010
    Posts
    169
    Thanks Paul...I appreciate your input. It validated what I did!

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

Similar Threads

  1. Unbound object not showing all of image
    By NISMOJim in forum Reports
    Replies: 11
    Last Post: 04-22-2011, 02:44 AM
  2. Replies: 0
    Last Post: 11-23-2010, 05:34 AM
  3. Replies: 1
    Last Post: 08-05-2010, 12:11 PM
  4. Replies: 0
    Last Post: 05-09-2010, 08:43 AM
  5. Link unbound form to bound form
    By Papote in forum Forms
    Replies: 0
    Last Post: 09-25-2008, 07:42 PM

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