Results 1 to 2 of 2
  1. #1
    sparker75 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Jul 2018
    Posts
    107

    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:	10 
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:	10 
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:	10 
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:	10 
Size:	36.1 KB 
ID:	35413



    Thank you for helping!

  2. #2
    sparker75 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Jul 2018
    Posts
    107
    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, 06:55 PM
  2. Replies: 9
    Last Post: 03-16-2014, 02:30 PM
  3. Replies: 3
    Last Post: 06-19-2013, 02:39 PM
  4. Transfer data off the form to word micorsotf
    By BorisGomel in forum Forms
    Replies: 4
    Last Post: 05-29-2012, 01:37 PM
  5. form data transfer to a report
    By poppinggizmo in forum Forms
    Replies: 1
    Last Post: 06-06-2010, 09: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
  •  
Other Forums: Microsoft Office Forums