Yes I know it says there is no database but it would sure be helpful when things don't work the way you show.

FYI- Access 2021 did not like The "RefreshProductList" as is shown in the SQL2 seminal lesson 4, It wants Me.Refresh.

Well, if I still had the database, then I would upload it. Whatever I've got is on the site. If I didn't save it at the time, then chances are I don't have it. As far as Access 2021, it should work with everything that I did in the class. Can you show me exactly what didn't work?

Here are the screenshots. Screenshot from your lesson. Screenshot of my Code that did not work and Screenshot of what I did to make code work. As you see I had to replace the "RefreshProductList" as you had in the lesson with "Me.Refresh"
in your lesson it is  11 minutes into lesson 4 of SQL Seminar 2.
Is this an SQL ANSI difference or change in Access?

RefreshProductList is a Sub Richard would have created in the Seminar.
The error message is telling you that Access can't find it.
It either doesn't exist or is in a Module, but it is Private instead of Public.