Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jun 2001
    Location
    Bethlehem, Pennsylvania, USA
    Posts
    67
    Thanks
    0
    Thanked 0 Times in 0 Posts

    add value from one form to another (Access 2k)

    Is there a way to have the value from an object in one form (Form A) automatically get updated to an object in a subform in another form (FormB) when I close Form A ?

    Thanks in advance

  2. #2
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Wellington, New Zealand
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: add value from one form to another (Access 2k)

    Hi Dave

    I would use the Close event of form a and then pass a reference from the control on form A to the control on form b ... ie.

    Private Sub Form_Close()
    forms!formBname.formBcontrolname = _
    me!formAcontrolname
    End Sub

    Make sure you replace the italics with the appropriate form or control names.

Posting Permissions

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