Hi ,
here what i've try but getting an error.
order date field on my subform is in format dd/mm/yyyy and my combo box on my main form only holds years in yyyy hoping to filter Order_date field on the subform via year. see below what i tried. guessing i need to change the Order_date field format to YYYY then apply the filter??
thanks in advance
shane
here what i've try but getting an error.
order date field on my subform is in format dd/mm/yyyy and my combo box on my main form only holds years in yyyy hoping to filter Order_date field on the subform via year. see below what i tried. guessing i need to change the Order_date field format to YYYY then apply the filter??
Code:
[Forms]![MonthlySpendCal]![CVorderQRYsubform].Form.Filter = "[Order_Date] = Format([Order_Date], "yyyy") = '" & Me.YearFormcbo & " '"
thanks in advance
shane