How to tempararily store a column value in a variable

[Bosch]

I need to get Max(column1) from a table and store in a variable temporarily.
How can I do that without having to create a control(TextBox) ?

Thanks
Bosch

 

[neileg]

If you don't want the text box to appear on the form you can make it invisible but still use it in your code.

 

[WindSailor]

Or...

Dim MyTempVariable as Integer
MyTempVariable = Max(column1) 'Or MyTempVariable = Val (Max(column1))


Thats if Max(column1) returns an actual value

 

[Bosch]

Thanks everyone for your responses.
Do I have define a recordset to do that?

Thanks