Grabbing The Maximum Value Of A Field's Contents

I need to evaluate a field's maximum value and then do an if
conditional:

if rs("havesubP") = true and rs("displaygroup") < MAX then ....

whereas MAX represents the biggest value in the records for the
displaygroup field (an integer datatype). I get an "Either BOF or EOF
is True, or the current record has been deleted.." error if i put any
type of comparison number (of course MAX is not a vbscript keyword)
that is larger than my largest displaygroup value in the dbase , as I
will loop thru all the records once this condition is met.