update field that has a space

Tim,
you need to clarify "doesn't work" part.

Any error messages?

Sorry... no error. Just nothing in the database field Noted By.
But put this on hold for the moment... it seems I have bigger issues.
I added a new field to the table called CreatedBy and I am attempting to use that instead. I removed the "Noted By" field from my SQL statement. I added CreatedBy so the SQL statement, add the field to the Add page, then on the Add page in visual editor I linked the CreatedBy field to the ID field in another table. Now when I attempt to save i get the following error:
Conversion failed when converting the varchar value 'joe@fakeemail.com' to data type int.
It looks like it's grabing the wrong field (Email instead of ID) and from the wrong row! That email address is from the first record in the lookup table. When I first bring up the Add form it shows the ID correctly, so I'm not sure what's happening when I hit save.

It appears that CreatedBy field is populated with email address which means you cannot link it to ID field which is numeric.
Without seeing your database and project file I can only make educated guesses.

Sorry to waste your time with this Sergey... I had put a trigger on that table a few weeks ago and had forgotten about it. It was messing up the insert. Everything works as expected now... no problem with dict("Noted By") = session("userid")
Thanks,

Tim