Are you using an @outlook.com address?
If so, check out this page.
https://support.microsoft.com/en-us/office/pop-imap-and-smtp-settings-for-outlook-com-d088b986-291d-42b8-9564-9c414e2aa040
If that was in response to my suggestion of using stored procedures, those are two different things. In case you weren't aware, stored queries are created in Access, while stored procedures are created in SQL Server.
Not sure why you need a recordset for this, couldn't you just use a single action query? Or, maybe you could move the logic to a stored procedure instead?
I tried to see what's going on with your forms, but it's taking too long, so I decided to test it with a new form, which seems to work. My guess is maybe your form got corrupted. Just my 2 cents...