sql - Ms Access VBA - Trying to call data from a combo box but only if a field is empty -

from code below want [kronosno] come database combo box if [rtwdate] column null.

set rs = application.currentdb.openrecordset(   "select * tblabsence [kronosno] = '" & me.cmbkronosno.value & "'     , [rtwdate] = '" & "is null" & "' ", dbopendynaset) 

don't treat is null variable, part of sql.

you need

and [rtwdate] null 

in string.