More Sql Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone help me with the syntax of the sql statement below. I'm terrible
at sql syntax (as you can see below.)


Thanks in advance, Rob
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
sql = "INSERT INTO tblDictation ( [fldDescriptionOfProcedure], [fldVisitNo],
[fldCreator] ) " & _
"SELECT [fldDescriptionOfProcedure], " & " [txtVisitNO], " & " &
[Me.fldCreator], " & _
"FROM tblDictationLU " & _
"WHERE tblDictationLU.[fldDictationLUno] = " & Me.lstTemplates.Column(0)



DoCmd.RunSQL sql
End Sub
 
Rob,

Try to reply Douglas J. Steele and J_Goddard's message from yesterday's post.
 
I've replied to Doug and J's message from yesterday. If I don't get a reply,
when is it kosher to place a new post?

Thanks, Rob
 
Hi Rob,

Doug replied on the same day as you. So does the reply works for you.
 
Back
Top