Poop Holy
asked on
Run-Time Error 3075: Syntax Error (Missing Operator) in Query Expression
Run-Time Error 3075: Syntax Error (Missing Operator) in Query Expression 'Lee' When I enter Lee in the name box
CurrentDb.Execute "INSERT INTO tblMRecord2 (Ename,Adate,Clinic,BilNo,Remarks,MLeave,MFees) Values (" & Me.Ename & "," & Me.Adate & "," & Me.txtClinic & "," & Me.txtBilNo & "," & Me.txtReasons & "," & Me.txtMLeave & ", " & Me.txtMFees & ");"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
compile error: expected end of statement
and you got answers, so just implement those answers.
It is not only the Name field (now Ename) that fails, it is also most of the other fields that will fail.