This should work if you put it in the DblClick event of ex:
Me.Parent.mon = Me.ex
Barry
"Eloy" wrote:
[Quoted Text] > 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
> "Barry Gilbert" wrote:
>
> > 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
> >
> > "Eloy" wrote:
> >
> > > 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
|