Simple One - Save new record

[ZOR]

I have been away too long from Access. I have a textbox on an unbound form. I type a number in, and press a button called save. It puts the contents of the textbox into a field called TTT in a table called Logs. Can someone please fill me in with the syntax. Thanks

 

[Golom]

CurrentDb.Execute _
INSERT INTO Logs (TTT) VALUES('" & txtBox.Value & "')"

 

[ZOR]

Dont think so? Syntax all in red!!!

Access 2003

Thanks

 

[Golom]

Sorry

CurrentDb.Execute _
[red]"[/red]INSERT INTO Logs (TTT) VALUES('" & txtBox.Value & "')"

 

[ZOR]

Keeps reporting OBJECT REQUIRED? Thanks

 

[Golom]

Are you running DAO or ADO? The above assumed DAO. If its ADO then

CurrentProject.Connection.Execute _
"INSERT INTO Logs (TTT) VALUES('" & txtBox.Value & "')"

 

[ZOR]

Thanks very much, the last one did it. Best regards