Results 1 to 2 of 2

Transfer data from one form to another

  1. #1
    sparker75 is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jul 2018
    Posts
    54

    Transfer data from one form to another

    Hello,

    I have a tabular form that I added a button on the end of each row. When I click the button I would like to transfer some data from that row into a new form

    Click image for larger version. 

Name:	Capture.JPG 
Views:	7 
Size:	58.5 KB 
ID:	35414



    I'm using the following macro to open the new form and set temp var

    Click image for larger version. 

Name:	Capture.JPG 
Views:	7 
Size:	25.4 KB 
ID:	35412



    On load of the temp form I use the following macro to SetProperty

    Click image for larger version. 

Name:	Capture.JPG 
Views:	7 
Size:	27.5 KB 
ID:	35415


    When I click the button the incorrect data is transferred into the new form and I get the following error.

    Click image for larger version. 

Name:	Capture.JPG 
Views:	7 
Size:	36.1 KB 
ID:	35413



    Thank you for helping!

  2. #2
    sparker75 is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jul 2018
    Posts
    54
    Problem solved!

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

Similar Threads

  1. help creating a form to transfer data from word to access
    By cc.caroline15 in forum Programming
    Replies: 9
    Last Post: 02-22-2015, 05:55 PM
  2. Replies: 9
    Last Post: 03-16-2014, 01:30 PM
  3. Replies: 3
    Last Post: 06-19-2013, 01:39 PM
  4. Transfer data off the form to word micorsotf
    By BorisGomel in forum Forms
    Replies: 4
    Last Post: 05-29-2012, 12:37 PM
  5. form data transfer to a report
    By poppinggizmo in forum Forms
    Replies: 1
    Last Post: 06-06-2010, 08:00 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
  •  
Tech Forums: Microsoft Office Forums