Doesn't

myVar = Textbox1.Text

not work?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Dave D" wrote in message
...
I need to pass the value entered on a form to a variable
in a module, have tried severial times and no joy. The
variable in the module I am trying to set is public, the
form item is a textbox. I am using the on exit event.