When using the code from lesson 4 in the calendar seminar:

SELECT CalendarID, ApptTime, Description FROM CalendarQ WHERE Forms!DatePickerF!StartDate>=CalendarDateTime AND Forms!DatePickerF!StartDate<CalendarDateTime + 1 ORDER BY ApptTime;

My list box does not update unless I hard code 11:59 PM in the StartDate field:
=Date()+#11:59:00 PM#.

I have added another ListBox named Day2 (the first ListBox is Day1.
The second ListBox will not update using the following code:

SELECT CalendarID, ApptTime, Description FROM CalendarQ WHERE Forms!DatePickerF!StartDate>=CalendarDateTime + 1  AND Forms!DatePickerF!StartDate<CalendarDateTime + 2 ORDER BY ApptTime;

It's possible that hard coding the =Date()+#11:59:00 PM# might interfere with this but removing the code still does not allow the ListBox (Da2) to update.

I have two consecutive dates together February 12 and 13 but the ListBox Day2 will not update. I will try to attach 3 screen shots of CalendarF and the two listboxes. I am not getting any error messages.