input must contain one table or query <- INSERT error

[Mitchell_Collen via AccessMonster.com]

Hi

I want to insert a string of my own data into a table based on the date. I do
not have a table or query to which I want to input only my own string. I
would like eventually append data to field based on a form's user input and
date value however for now and while testing the syntax before adding the
form...I am already getting a n error. Do you know how to add a value to
table without needing a query or table for input? Thanks MC

INSERT INTO AutoResult ( siteTested ) VALUES ('myuniquestring')
WHERE AutoResult.dateImported = '7/1/2009'

 

[KARL DEWEY]

Try this --
INSERT INTO AutoResult ( siteTested )
SELECT [Form]![YourFormName]![TextBox]
WHERE AutoResult.dateImported = CVDate([Form]![YourFormName]![DateTextBox]);