sql syntax error

R

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
 
D

Dirk Goldgar

RobUCSD said:
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
Click to expand...

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?
 
R

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
 
Top