I haven't given up, but I wont be around for a week or so after today.
Giving the field names in the sql statement should work. If it doesn't I don't know why but then I don't understand the way you are opening the recordset. I've never seen it done that way before, I always use the sort of code I wrote in post #4.

So you are connecting to Access. Is the database that you are connecting to another file or the same file that you're coding in?
I would suggest that you build the application in one Access file to start off with. Tables, queries, forms, everything all together.
Then, as I said before, you don't need to bother with connections. All you need to write to add, delete or update data is, for example

currentdb.execute fcnGetStrSQL

Once you have everything working the way you want you can split it up and use whatever connection method you like.