ClaraBarton
Registered User.
- Local time
- Yesterday, 23:08
- Joined
- Oct 14, 2019
- Messages
- 427
Good morning. I went to bed with this problem and received no enlightenment overnight. Why doesn't this work:
Code:
strSql = "INSERT INTO tblItemDetail ([DocNo], [fDrawerID], [fItemID]) " & _
"VALUES (" & intDoc & "," & intDrawer & "," & intNewID & ");"
With CurrentDb
.Execute strSql
End With
?strSql
INSERT INTO tblItemDetail ([DocNo], [fDrawerID], [fItemID]) VALUES (0,0,0);
?intDrawer
1
?intDoc
2
?intNewID
188