queries resulting resulting is a drop-down

[Guest]

Is it possible to have a query pull information from a drop-down? I have a
report based off of a query including criteria: [dept] and between [start
date]and[end date]. Is is possible to have the result of the [dept] create
a drop-down menu to enter the data?

 

[John W. Vinson]

Is it possible to have a query pull information from a drop-down? I have a
report based off of a query including criteria: [dept] and between [start
date]and[end date]. Is is possible to have the result of the [dept] create
a drop-down menu to enter the data?

Yes. You need to create a little unbound Form, frmCrit let's call it; this
could have a combo box cboDept and textboxes txtStart and txtEnd. Use

=Forms!frmCrit!cboDept

and

= Forms!frmCrit!txtStart AND < DateAdd("d", 1, Forms!frmCrit!txtEnd)

as criteria (the dateadd is to include records on the last day of the date
range if the field contains a time portion).

John W. Vinson [MVP]