I have developed a form [sanreq] that allows a user to select a type of youth for report data [ytype] which works fine. My problem is that they now want to be able to chose youth that are active (disdate would be null) or inactive (disdate would not be null) and I can't figure the best way to do this. Should I have a check box that if is checked would equal one situation (i.e., active) or an unbound text box as I did for youth type? Either way I am not sure how to code this. Can someone advise me on this please. Below is the code that uses the disdate variable from the key table that works in the query.
WHERE (((Attendance.stype) Is Not Null) AND (([ytype]=[forms]![sanreq]![ytype] Or [forms]![sanreq]![ytype] Is Null)=True) AND ((Names.disdate) Is Not Null))
ORDER BY Attendance.dcdate DESC;
Megan
WHERE (((Attendance.stype) Is Not Null) AND (([ytype]=[forms]![sanreq]![ytype] Or [forms]![sanreq]![ytype] Is Null)=True) AND ((Names.disdate) Is Not Null))
ORDER BY Attendance.dcdate DESC;
Megan
