I uses this query 'SELECT Format(DateSerial(Year(Date())+YearNum,1,1),"yyyy") AS [Year] FROM tblYears;' as a combobox's rowsource which will dropdown a list of years.
For example the combobox containing the list 2011, 2012, 2013. So when the current year's reaches to the end and turns into a new year, and when the combobox's executed (On Click), the year list will not be automatically updated to 2012, 2013, 2014 will it? I guess I have to executed the query each time when it's reaching a new year? How do I execute that query?
Thank you
Phucon
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar