queries resulting resulting is a drop-down

J

Jeem

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?
 
J

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?
Click to expand...

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)
Click to expand...

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]
 
Top