Hi,
I have solved this on my own, for anyone who may be interested or having similar issues what i did was have my Date combo box row source as
SELECT DISTINCT tblAttendance.dataDate FROM tblAttendance WHERE (((tblAttendance.dataDate)>Date()-15)) ORDER BY tblAttendance.dataDate DESC;
and an...