Results 1 to 2 of 2
  1. #1
    Khalil Handal is offline Competent Performer
    Windows 10 Access 2003
    Join Date
    Jun 2016
    Posts
    237

    copy value from one form to another

    Hi,
    I have a main form Form1 that has a control on a subform in it. If value is not found (not in list) a second form is opened Form2.
    The user selects a value from form2, When closing form2 the value (dialogue result) should be copied to the control on the subForm in form1.
    How can I do this?



    Khalil
    thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    use the full path of the other form before you close. Use the BUILDER it always get the path name correct.

    forms!myForm1!subform!form!myControl = me.myControl (on from 2)

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

Similar Threads

  1. Copy values from Access form to online webpage form
    By themushroomking in forum Access
    Replies: 5
    Last Post: 07-21-2017, 08:21 AM
  2. Replies: 2
    Last Post: 10-16-2015, 07:03 PM
  3. Copy data from form to form by clicking a button
    By tswack in forum Programming
    Replies: 3
    Last Post: 02-24-2014, 12:01 PM
  4. Copy from one form to another
    By Adam858 in forum Forms
    Replies: 3
    Last Post: 07-29-2010, 01:27 PM
  5. Replies: 0
    Last Post: 11-10-2008, 12:32 PM

Tags for this Thread

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