Ok thanks Doug......that did it.
Kenny
"Douglas J. Steele" wrote in message
...
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