Select Date – Run Report (Access97)

Topic

New Reply

I am having a form with a list box where dates should be displayed.
I am Running Report that is suppose to run for Selected in ListBox dates.
What is the best way to do it to insure Report performance? Simple but forever…
Also multiply dates can be chosen.

Report is based on table that has Date field or it can be a query that pulls Distinct date to display in ListBox.
Thanks

Reply | Quote

Replies

Set the MultiSelect property of the list box to Single or Extended. This allows the user to select more than one item.
post 205119 contains a method for using the selected items in the WHERE-condition of an SQL statement. That technique can easily be adapted for use in opening a report.

Reply | Quote

Thank you HansV, will try.

Reply | Quote