Having trouble with moving text to table

[geoffwbailey]

I am trying to store the name of a table in another table to be able to access it later with a combo box. I am storing it in "TableNames" in the column "Table Name". I am trying to store values from an unbound text box "tablename" on the form "MainForm"



This is the code i am using

CurrentDb.Execute "INSERT INTO TableNames (Table Name) Values(" & MainForm.tablename & ")"

Any help is appreciated
Thanks

[pbaldy]

If it's a text value, it needs to be surrounded by single quotes (just inside each of the parentheses). Also, I think the form reference is off:

Forms Refer to Form and Subform properties and controls

If there is really a space in your field name, it would need to be bracketed.

[geoffwbailey]

That worked. Thanks a lot

[pbaldy]

No problemo; welcome to the site by the way!