Your subform is showing the wrong records, and the culprit may be hiding in plain sight. Think you can go 5 for 5 on Access subforms? #msaccess youtu.be/4rQBG2r8M6c

Connect Many-to-Many Relationships with a Junction Table - 599cd.com/blog/display-artic…

Too many versions of the same Access query? There is a way to make the database build the exact one it needs. Seriously. #msaccess youtu.be/uTmMVI8ztlY

Tiny Access trap: can you delete a label without nuking the text box attached to it? Most people guess wrong the first time. Try the forms quiz. #msaccess youtu.be/jw7MDwpw7Mo

Access Expression Builder looks like a wall of random buttons... until you need one value from an open form. Then things get interesting. #msaccess youtu.be/B0-gzmKTOg4

Tiny VBA mistake. Completely believable data. Can you spot the Access SQL INSERT bug before it logs the wrong Martian payroll? #msaccess youtu.be/cAz5UDr-Cc0

"Access was the worst database"? That take skips one inconvenient question: what were businesses actually trying to build? #msaccess youtu.be/Fd7vrYtSm1A

Still copying the same Access code into every database? There is a better way, and updating it doesn't have to be a manual disaster. #msaccess youtu.be/C2yDj7Bcc9Y

Works in queries. Works in forms. Then Access suddenly claims it has never heard of it. Table validation rules have some weird limits. #msaccess youtu.be/SLo7utT12ik

Paid orders should be locked down. But can users still copy what they need? This Access quiz has a few gotchas. #msaccess youtu.be/dL91IYR3ItM