
Signature
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.
Yes, the doubleclick module causes some things to happen, and what I now want
to happen FIRST is that it captures the value I described from the subform
and puts it in the global variable.
The global variable is defined in a separate "Globals" module so it's
accessible from anywhere, not just from the subform-associated code.
I've experimented with several different variations of the
Forms!MainForm!subForm1.Forms.Controls "name-ology," adding or taking out
various pieces to try to find the right object string, but haven't hit on the
right one yet. As I said, the closest I've come does indeed capture a value
and place it into the global variable, but it's Value1 from the FIRST record
in the subform, not from the record where the double-click action happened.
> Are you putting code in the DoubleClick event of the Value2 control in the
> SubForm? Where is the Global variable defined? What code have you tried?
[quoted text clipped - 15 lines]
> >the FIRST record displayed in subform1, no matter which record the
> >doubleclick happened in. Help, help, help.
ruralguy - 12 Mar 2007 19:59 GMT
When you click or doubleclick in a field in a continuous form, that record
becomes the Current Record for the form. If the code is in the DoubleClick
event of the control for Value2 then I would thing that GlobalVariableName =
Me.Value1ControlName would do it. Using your names of course!
>Yes, the doubleclick module causes some things to happen, and what I now want
>to happen FIRST is that it captures the value I described from the subform
[quoted text clipped - 15 lines]
>> >the FIRST record displayed in subform1, no matter which record the
>> >doubleclick happened in. Help, help, help.

Signature
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.