myVar = Textbox1.Text

but I don't think that is what you mean (although it is what I think you are
asking :-))

--
HTH

Bob Phillips

"tonyDeBrasco" <tonyDeBrasco.1skhfy@ wrote in message
...

Hi,

How do you assign whatever is entered in a textbox in a form to a
variable?

For example I want to be able to select up to 6 different worksheets
and within these worksheets then go and single out the spreadsheet
titled Totals. Then I must create another spread sheet which will
solely contain the data that is entered on all the individual totals.

This is similar to my other post except the added complexity of forms
is now in play. I have already set the form up just need help with the
hard part.

Many thanks,
Tony


--
tonyDeBrascoPosted from http://www.pcreview.co.uk/ newsgroup access