Using some, but not all list boxes in a form to access query.

[Khatru]

I have a form which generates a report from three different lists. The lists are: Segment, Term and Academic Year. I use the following statements in the Query to access the information.

(IIf(IsNull([Forms]![DetailInstructorForm]![SegmentList]),"*",[Forms]![DetailInstructorForm]![SegmentList]))
(IIf(IsNull([Forms]![DetailInstructorForm]![TermList]),"*",[Forms]![DetailInstructorForm]![TermList]))
(IIf(IsNull([Forms]![DetailInstructorForm]![YearlyList]),"*",[forms]![DetailInstructorForm]![YearlyList]))
The form works great when all the information is used but I would also like to use it when I want to use just one list (Like AcademicYear). When I try this by putting a blank field in the list it does not generate any data.
Any thoughts? I am using Access 2010.


Thank You.

[June7]

Try:

LIKE [Forms]![DetailInstructorForm]![SegmentList] & "*" Or Is Null
LIKE [Forms]![DetailInstructorForm]![TermList] & "*" Or Is Null
LIKE [forms]![DetailInstructorForm]![YearlyList] & "*" Or Is Null

[Khatru]

Thanks. Exactly what I needed. Owe you a beer.