i need help in sql query my coding is as under

Dim MRUNYEAR As String
MRUNYEAR = "0405"
Set fgrs = New Recordset
fgrs.Open "select CT3HDR.CT3ID, CT3HDR.CT3NO,
format(CT3HDR.ct3date,'dd/mm/yyyy'), suppmast.suppname FROM CT3HDR INNER
JOIN suppmast ON CT3HDR.suppID=suppmast.suppid WHERE
CT3HDR.RUNYEAR=MRUNYEAR ORDER BY CT3HDR.CT3NO", db, dbopenstatic,
adLockOptimistic

i am receiving error "no value given for one or more required parameter"

if i give '0405' directly in the query than it is running fine. so how
to give mrunyear variable in the query.

thanks,
ganesh



*** Sent via Developersdex http://www.developersdex.com ***