how to populate a combo box with data from Date/Time Field

[lugnutmonkey]

How can I populate a combo box with the years present in a Date/Time field?



I would like to setup a combo box that will only contain the years available in a Date/Time field. So that the user can't select a record from a year that has been moved to an archive table.

[jzwp11]

You can use a query and base the combo box on the query

SELECT DISTINCT Year(yourdatetimefield)
FROM yourtablename

[alansidman]

After opening this link, scroll down to the section on combo boxes. Three tutorials there.

http://www.datapigtechnologies.com/AccessMain.htm