New client has just upsized tables to sql
It seem everywhere they are using any domain aggregrate function
(dlookup,dcount,dsum) they are getting this error
dim mycount as integer
mycount = Nz(DCount("[MenuNumber]", "qryModifiers"), 0)

btw this works
Dim mycount As Integer
Dim mytable As String
mytable = "tblpos_data_hold"
mycount = DCount("[line]", mytable)
debub.Print mycount

is the error (and not the real error I may add) because they referenced a query object?

do I need to use a reference for the recordset as in the example?