NO PLACE in that code do you actually *OPEN* a recordset!
If you want to get some records to display, you *MUST* do SELECT query.
One more time: An INSERT query does *NOT* request any records at all for display. INSERT and SELECT (and DELETE and UPDATE) are ENTIRELY separate operations, and *ONLY* a SELECT (out of those 4 commands) will actually return any records.
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.