Split form variables not retaining value

[tuna]

Hi, is anyone else finding that form variables don't retain their value in split form mode? Is there anything that can be done? Thanks.

 

[boblarson]

Need more info than that. How are you declaring them and where?

 

[tuna]

Thanks - I mean in all events that originate from the datasheet part of the split form fails to retain module-wide variables - i.e. if I have a hyperlink set on field Field1, something simple like this would fail to give the desired result:

Option Compare Database
Option Explicit

Private lngTest As Long

Private Sub Form_Load()

    lngTest = 5

End Sub

Private Sub Field1_Click()

   Debug.Print lngTest

End Sub

debug.print prints "0" - lngTest appears to evaluate to its default value despite being set during the on load event. Thanks.