Hi guys,

I have a SQL string here that is intended to add the contents of a textbox
into an unrelated table at the click of a button(the table is the rowsource
for the textbox).

DoCmd.RunSQL "INSERT INTO tblLetdownplaces([Place]) VALUES( " & Place.Value
& ");"

When I run this, it brings up a little dialog box asking me for the value of
whatever text I have entered into the textbox.......eg. if I type in ABCD,
it will ask for a value for ABCD. If I enter a value into the text box, it
accepts it and places in the table.

What am I doing wrong?

Thanks guys.

Kenny