Dialog Box Form

[Alex Motilal]

I have created a pop up Dialog Box Form with the following controls:

1. A Combo Box from which Cotton Season can be selected (eg, 2015-16, 2016-17 & so on. A Cotton Season in India starts from 1^st October & ends in September 30^th).
2. A Text box to enter the Start Date.
3. A Text box to enter the End Date.
4. A Command Button to generate Purchase Report.
What I need is after selecting a Season the Report should generate for all the dates of the Season in no dates are entered.
If a Start date is entered & the End date is left blank, the Report should generate from the start date to the last date of the season selected.
If both the Start & End dates are entered, the Report should generate for the Date Range entered.
Also a message box should appear to warn wrong date have been entered if the dates are not related to the Season.
There is a tblSeason with columns txtSeason, dtStart & dtEnd apart from the ID.
Alex

[June7]

Use VBA to build criteria string. Here is an example of code that conditionally builds criteria string http://allenbrowne.com/ser-62code.html