Unanswered: Date Validation Based on Calendar Quarter
I am using Access 2007 with a SQL Server back-end. I have a combobox with 'Q1, Q2, Q3, Q4' and a textbox to enter a date. Is there a way to restrict the mm/dd according to what Quarter is selected? For example, if I choose Q1 then I am only allowed to enter a date from 01/01/xx to 04/01/xx.