Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2009
    Posts
    2

    Angry Unanswered: How move data from one form to another

    I am trying to move data into a field on one form that is from another form. I've read a hundred threads and can't see that I am doing anything wrong, but it doesn't work. Can anyone help? Here is the code I am using....

    Private Sub ServFlg_AfterUpdate()
    If Me![ServFlg] = True Then
    Me![ServFlgNo] = False
    Me![Servrpt#] = Forms![Service]![Service#]
    End If
    End Sub

    In essence what this does is if the "ServFlg" field is true then make the "ServFlgNo" field false (this works), and then go to the form called "Service" and copy the data in the field called "Service#) over to the field in the present form called "ServRpt#", but it doesn't work.

    Any assistance would be GREATLY appreciated.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Looks fine to me. Do you get an error, or what? Is the Service form open? Is it a subform?
    Paul

  3. #3
    Join Date
    Jun 2009
    Posts
    2
    No, it's just another form.

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    And the others?

    Quote Originally Posted by pbaldy
    Do you get an error, or what? Is the Service form open?
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •