Have you checked spelling? Can you share the source SQL for one of the list boxes that aren't working that has a data entry for that day?

I remember this making 42 listboxes fun and I know the code works, I would assume a spelling error.

Thanks for responding so quickly I will check

Yeah, I will also concur that if SOME of the boxes are working and others aren't, something's spelled wrong. Either the name of the box itself, or the code.

Issue does not appear to be spelling. i can copy and paste aa working list box and it ends up being empty as well. After some further more digging I noticed that once in a great while it pops up with a message that it "can't load any more databases'. Does it more often when coming out of development mode.
The tables are linked to SharePoint lists. Googled it and found that SharePoint list basically doubles the amount of connections. And it is pulling data from a query with 10-12 related tables, So I tried a test by doing a "Make Table" query and pulling data from the table made from the query and put on local drive. And this seemed to have fixed the issues.

Yeah, I'd definitely suggest that if your data is online. Glad you figured it out.