selecting nothing from dropdown box

[mikeder]

Hi,

I have a form that contains a dropdown box that list 8 project managers. The form also contains fields where you can enter a date range. The idea is to select a project manager and date range and have the form generate a report of all activity for that project manager with the date range.

I want to be able to not select any project manager from the dropdown menu and just enter in a date range and have the form generate a report for all project managers within the date range.

My problem is, when I don't select a project manager from the list and just enter in a date range, the report that is generated is blank.

Anybody know how to make it so that by not selecting anything in the dropdown, it will default to include all of the entries in the list?

Thanks

 

[ColinEssex]

Sounds like you need to select "all" from the combo.

There is a "Developer Solutions" CD that comes with Access or is available from the MS Download centre if you haven't got one. This tells you how to select "all" from a combo box.

Col