my issue is "Why no fields attached to record. It reads 37,818 records , then exits"
in your original code you are returning recordcount immediately after opening the recordset - this will return 0 until the recordset is fully loaded. You need to .movelast before checking the recordcount
Error 3265 - Item cannot be found in the collection corresponding to the requested name or ordinal. This error is usually caused by a field missing from the database.
In your original code you have
txt1 = rs!ImlJobID
in your query you have
m1tclcropped.lmlJobID
looks to me like they are different - original ImlJobID, querylmlJobID
seriously doubt this has ever worked pre 365 or not