Hi All
I have a form that has 3 combo boxes for the user to enter a date, one each for day, month and year - so far so good.
The problem I'm having is trying to pass this date into a query, I have the query criteria as dateValue([forms]![cboDay]&"\"&[forms]![cboMonth]&"\"&[forms]![cboYear]) but this doesn't work, it says it's too complicated to be evaluated?
Please can someone point me in the right direction?
Thanks
I have a form that has 3 combo boxes for the user to enter a date, one each for day, month and year - so far so good.
The problem I'm having is trying to pass this date into a query, I have the query criteria as dateValue([forms]![cboDay]&"\"&[forms]![cboMonth]&"\"&[forms]![cboYear]) but this doesn't work, it says it's too complicated to be evaluated?
Please can someone point me in the right direction?
Thanks