Validation Rules of Dates in Tables

[gareth001]

Hi, I'm wanting to list out years in table 1 which will contain years from 1901 through to 2050 (future proof). Table 1 will be used as a combo box lookup in table 2, but I'm only wanting the years which are valid to be used, e.g. 2005 and back.

Is there a way to not include 2006 onwards in the combo box list, or to not allow for it to be clicked? I'm thinking it can be done by the validation rule but not sure on the syntax required.

Thanks for your help in advance.

Gareth

 

[lupins46]

The combo box rowsource query will do this for you if you modify it to include entries which are:
<=year(Date())

 

[gareth001]

Great that works wonders, also opened me up to using queries on combo boxes, thanks.