crosstab query to display list of a field to select

[Krish]

I have a crosstab query with two rows, with criteria to prompt to enter the
name of the department and /or a category within the department. How can I
make a list visible to the user to select for either rows, so that the
selection from the list will be pasted to continue processing the query?

Thank you all for your valuable guidance.
K

 

[Duane Hookom]

You should create a form with a list box or combo box to use as the
criteria. You then must enter the form and control name into the crosstab
query parameters. For instance:
Forms!frmDates!txtStartDate Date/time