I Have a form with a combo box populated with a value list , Months (JAN-DEC), Quarters (QTR1-QTR4), and YTD (JAN (YTD) - DEC (YTD). The query that I’m trying to run has only the Month names available. I have added [Forms]![frm_Main Form]![frm_Month_Output] to my query. When choosing the month from the combo box the query runs and brings back the expected results. . I tried creating an IF statement (macro) IF [Forms]![frm_Main Form]![frm_Month_Output] = ‘JAN(YTD)' then month = ‘JAN’ , FEB(YTD) would equal JAN + FEB etc, same for the quarters. I have attached this macro to the combo box but get no results when choosing either the YTD or quarter from the drop down list .Can someone help with getting this to work?