vba - Form Where User Enters Multiple Fields to Run a Report, Leave Blank to Show All -

i have working form/query/report user enters start date, end date, , type, run report of deposits based on parameters.

the user enters info on form (called 'typeanddateselectdeposit'):

a report generated using query:

i want user able either select 'all types' option, or leave type blank, , have types show on report.

how make happen? @ point, if type left blank, nothing shows on report, because every deposit has have type.

if user selects value other 'all types', want rows match value.

but if user selects 'all types' or leaves combo blank, don't want filtering based on deposittype.

you can write conditions query's where clause ...

where     [put date selection criteria here]     ,     (            deposittype = forms!typeanddateselectdeposit!type         or forms!typeanddateselectdeposit!type = 'all types'         or forms!typeanddateselectdeposit!type null     )