Best way to use SQL statements in VB code

[Jorgandr]

What is the best way to include an SQL statement in my VB Code and then assign the value to a variable? For example, when my form opens I would like to be able to select the max value from a table and then store it in a Global variable??

 

[gol4]

The easiest way would be to use the dmax function

variable = dmax("field","table","any criteria&quot

the best way would be to use a recordset

'Dao
dim strsql as string
dim rst as recordset
strsql = "select max(field) from table where criteria"
set rst=currentdb.openrecordset(strsql)
rst.movefirst
variable = rst.field(0)
rst.close
set rst = nothing