updating fields

[Guest]

I would like to dblclick on a field in a subform and send the field data to a
field in a different form. I've been researching it but I don't really know
what to look under.
eloy

 

[Guest]

Assuming the other form is open, this will work.

Private Sub txtSource_DblClick(Cancel As Integer)
Forms!theOtherForm!txtDestination = Me.txtSource
End Sub

If you want to send the value to the subform's parent form, you can use this:
Me.Parent.txtDestination = Me.txtSource

Barry

 

[Guest]

thanks for the help, Barry. I'm not very good at this sort of thing so
therefore I'm doing something wrong. The parent form is "Lesson Plans". The
subform is "TEKS". The name of the db is Lessonplan. I would like to dbl
click on field "ex" in the subform and send that data to field "mon" on the
parent form. I am also entering the info you provided in the "on dblclick"
section in the properties table. Hope this helps you help me. Thanks again.
Eloy

 

[Guest]

This should work if you put it in the DblClick event of ex:
Me.Parent.mon = Me.ex

Barry