Hi Richard
I finally cracked it. Anyone who does not live in the US needs to know this. Assigning a .rowsource to a listbox will NOT work properly if you are using dates as criteria with a SQL.
The first part of your expression is fine but after the "SELECT * FROM CalenderT WHERE " & "CDate=" - the next part has to be USDate format.
USDate = "#" & Month(TD) & "/" & Day(TD) & "/" & Year(TD) & "#"
Some of the listboxes were OK some were not. I had to requery each listbox or click the refresh all to see the results.
Once I used the USDate format all my problems were fixed. As you live in the US. I think it would be difficult for you to view my problem. Access is not entirely International we have to find ways to fix what the Access Team have missed. They do know about it. Pity they have not fixed it. But I am very happy my calender now works as well as yours.

Regards Alan Hill

---

Reply from Richard Rost:

Thanks for posting that, Alan.