Select All from combo box

[daveUK]

Hi Guys

I have a search form that allows users to search for records between certain dates and a combo box that will allow them to specify the records of a certain campus.

At the moment the user enters the dates and the campus, they click on the search cmd button, which runs a query and a report is opened. This works well. But I'd like to give the users the option of viewing the records of ALL campuses between the specified dates.

Any ideas?

Dave

 

[AncientOne]

Add a second command button that runs a query to pull in all records?

 

[IgorB]

Your combox now should based on Union type query which will contain value "All".
Then in VBA code in report describe cases of combobox and change report recordsource on fly.

 

[daveUK]

Thanks, I've got it sorted now

Dave