Evidently, I'm having one of those moments. Any help would be appreciated.
Code:
dim dbs as Database
Set dbs = CurrentDB
dim x1 as Date
x1 = Now()
dim w1 as long
w1 = Me![cboEntity].Value
dim mySString as String
mySString ="INSERT INTO tblSession (fkUserID, fkEntityID, sessiondteStart) VALUES (Me![txtUID4S], w1,x1)"
CurrentDB.Execute mySString, dbFailOnError
Code is throwing error 3061 parameter and I had some syntax errors as well in the vbeditor.
with the x1 variable I have tried several versions with combinations of '"# " & x1 & "#"', but can't seem to get it to work.
Thanks, for any help.
Jim