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