Assuming that you're trying to load Text values and not Numeric ones, you
need quotes around your values. Try

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

Chr$(34) is the " character.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



Kenny wrote in message ...
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