On form #1 I have a combobox that allows the user to select records from a year. The actual date fields in the table are short date like 1/12/2016. But the combo-box displays "2016" because of the format in the query like:
But then using a command button under the combo-box I'm trying to open a 2nd form to display all the records that had a TargetResolutionDate in 2016.
I've tried this but it doesn't work:
DoCmd.OpenForm "frmProjectIssue", , , "[TargetResolutionDate] = #" & Format([cboProjectDate], "yyyy") & "#"
Can someone help?