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

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote