db recordset query help

[elios115]

can anybody help me with the code of this:



Set el = db.OpenRecordset("select * from transfertable where jobID = " & Form_job.jobid And deliverytick = true, dbOpenDynaset, dbSeeChanges)

kindly correct it for me because it is giving "type mismatch error"

please note that deliverytick is a yes/no check box with true/false defaults


the purpose of this is to choose the recordsets from the database where 2 criterias match (jobID = " & Form_job.jobid and deliverytick is checked on the form therefore its value in table is true)

[ssanfu]

Try

Set el = db.OpenRecordset("SELECT * FROM transfertable WHERE jobID = " & Form_job.jobid & " AND deliverytick = TRUE", dbOpenDynaset, dbSeeChanges)

Note: there is a quote after TRUE

[elios115]

exactly right!!

thank you for your help

[ssanfu]

You're welcome.

Ready to mark this solved?