Holiday List Box Issue - Work Days in Microsoft Access


	Back to Work Days Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Holiday List Box Issue

Walter Hamilton

4 years ago

I've added a List Box to display the holidays that are listed between the StartDate and EndDate. I've done a couple tests but the list box doesn't always display the entire list of holidays. For example, StartDate: 1/1/2022 and EndDate: 12/31/2025. The list box only shows the holidays for 2022 - 2024, but I have holidays listed through 2026. I'll post a screenshot of the Row Source for the Listbox.

	Walter Hamilton OP @Reply 4 years ago

	Walter Hamilton OP @Reply 4 years ago
I think I figured it out. I just had to do a Me.HolidayList.Requery after the IF statement. Everything seems to be working fine.

	Dan Jackson @Reply 4 years ago
Love these self-fixing problems! Done it so many times myself

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Work Days.

Next Unseen

New Feature: Comment Live View