Syntax Error

[swmorin]

This is really bugging me

CurrentDb.Execute "INSERT INTO tbl_instructor_dates" _
          & "(Instructorid, dagb) " _
          & "(" & instridrs![instructorid] & " " & _
          ",# " & [Forms]![frm_create_instructor]![Text23] & " #;)"

 

[tehNellie]

CurrentDb.Execute "INSERT INTO tbl_instructor_dates" _
          & "(Instructorid, dagb) " _
          & "[b]VALUES[/b] (" & instridrs![instructorid] & " " & _
          ",# " & [Forms]![frm_create_instructor]![Text23] & " #)[b];[/b]"

 

[swmorin]

thanks nellie i just noticed it was hoping to delete before i looked crazy stupid

 

[tehNellie]

heheh. During development I find it can be helpful to dump all of that into a string and debug.print it so I can see what the database thinks it's receiving versus what I think I'm sending it (plus you should be able to copy and paste the string output into the query designer to test there too).