simple Y/N answer required for SQL troubleshoot

[battenberg]

Hi,

I am trying to use an 'INSERT INTO' sql statement to write values to a table.

I sucessfully used this statment in another part of my database to write a new record.

I have copied the code and substituted the values, fields and relavent strings,
but now i am getting a syntax error. The syntax has not really changed!

I was wondering if in order to use this 'INSERT INTO' statement, the table had to be opened for editing using a form or a query to address the records...

can you use this method to write to an unopen table?
save me barking up the wrong tree!!!

 

[RuralGuy]

can you use this method to write to an unopen table?

The answer is YES!

 

[battenberg]

Thank you once again RG!

 

[RuralGuy]

Glad to be of service.

 

[battenberg]

had one of those 'cant see wood for trees' moments!!!

 

[RuralGuy]

Been there, done that!