Setting global variables

[Remster]

Folks



How do I set a global variable to a value in the current record? I have ...

 
Dim xyz As Integer

... at the top of my module and ...

 
Set xyz = Me!FieldName

... in the On Current event, but I get an 'object required' error with 'Set xyz =' highlighted. Any ideas?

Thanks

Remster

[Remster]

As is so often the case, I've discovered the answer shortly after posting. I've removed the word 'Set' and it works now.