updating fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
Back
Top