sql syntax error

[RobUCSD]

with the statement beloww I want poplulate a tbl by dblClk on lstRNnotesLU.
I get a sql syntax error. Any hlp greatly apprciated. Thanks, Rob


Dim sSql As String
sSql = "INSERT INTO tblRNnotes WHERE fldRNnotesNo"
CurrentDb.Execute sSql
Me.Refresh

 

[Dirk Goldgar]

with the statement beloww I want poplulate a tbl by dblClk on
lstRNnotesLU. I get a sql syntax error. Any hlp greatly apprciated.
Thanks, Rob


Dim sSql As String
sSql = "INSERT INTO tblRNnotes WHERE fldRNnotesNo"
CurrentDb.Execute sSql
Me.Refresh

There's nothing there that tells what data is supposed to be inserted
into what fields, and I have no idea what the WHERE clause is supposed
to do. Can you state clearly what should be inserted into where?

 

[RobUCSD]

Dirk, I probably shouldn't have sent this one off. I'm way over tired and
have no idea what I'm doing. Sorry for wasting your time. Tomorrow I'll try
to put my thoughts together better.

Again, sorrry for the inconvenience. Thanks, Rob