Getting default value as a parameter in access?

[prabhafriend]

I know we can make a criteria by getting a parameter but I need to give a default value on user's prefrence. Possible in a parameter query?

[ranman256]

If you are using a saved query , change the [param] box in criteria to the users preference.
else
if you are using code, you must open the querydef, set the param to the preference, save.


vUserPrmSet = 8
set qdf = currentdb.querydefs("qsMyQry")
qdf.parameters("Month") = vUserPrmSet
qdf.close
set rst = qdf.openrecordset