Hi Guys
Code:
CurrentDb.Execute "INSERT INTO Payment_Details (Lecturer_ID,Unit_ID,Class_Date,Class_Type,Level_Of_Unit,Session_ID,Payment_Period_ID,Time_In,Time_Out) " & "VALUES ('" & Me.Combo287 & "','" & Me.Combo301 & "','" & Me.Text297 & "','" & Me.Text214 & "','" & Me.Combo309 & "',,'" & Me.Combo245 & "','" & Me.Text233 & "','" & Me.Text235 & "','" & Me.Text237 & "','" & Me.Text320 & "')"
I tried above insert into statement, but when i click on this button i get the error "Syntax error in INSERT INTO Statement". Any solutions to overcome this error?
Thanks In Advance