Thanks very much for your help. I think I was previously using CurrentDB incorrectly and gave up on it too soon. Because with your encouragement to try it again and fixing the query string, I now have it working:
Set dbs = CurrentDb
QueryStr = " INSERT INTO dbo_Suppliers ([Part...