1) I don't see why you're using a split form for this. Perhaps your db sample doesn't really reflect what this is for?
2) you should turn on "require variable declaration" then go back to your existing code and add Option Explicit under Option Compare, or you deserve all the undeclared variable grief you get! I cannot for the life of me understand why this isn't an MS default.
3) I'm going to guess that it doesn't work for you because it (listbox) is unbound and you never requery it. I would try that on the form Current event:
Me.combo20.Requery
4) I suggest you do not have special characters (save perhaps underscore) in any object name (e.g. Attendance Log1)
Last edited by Micron; 10-17-2020 at 09:39 PM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.