Combobox with dates

[VaYooper]

Run into a bit of an issue with a combo box that has dates. When I click on a date I receive:

Run-time error '3464': 'Data type mismatch in criteria expression'

Am I receiving this because I have declared it a string when I should declare it something else?


My other question for whenever I get the first part fixed. Is there a way that instead of having all the possible dates to select from, that I could simply have three options available: Within a year, More than a year, and no date. (Once I click on one of those three options, I will filter records that have a date within the past year, over a year, or no date at all. How would I be able to achieve this? Thank you in advance.

 

[pr2-eugin]

Hello VaYooper, Welcome to AWF

Well to be honest, there is not much info on why you get the info. The problem being you have not showed what you have the combo box, the rowsource of the setup.

Regarding your second query. So you want a Combo Box to have three options, within year (Today-365? or 01 Jan 2015 - Today?), More than a year, and No Date? This might involve VBA or three Queries. Which one do you prefer? How do you want the results?

 

[VaYooper]

Thank you for your response.

To avoid the back and forth.. the file I'm working with is here:
yooperonline.c**/User_Dashboard2.accdb

The second part.. yes 'Today - 365'. Or essentially: Greater than Today-365/Less than Today-365/No date.

Hope I'm not being too vague, still learning so my terminology is a bit amateur. Not looking for someone to fix it, just to point me in the right direction. Thanks