compile error: expected end of statement

You have some misplaced " and missing spaces, try this.

CurrentDb.Execute "INSERT INTO tblMRecord2 (Name,Date,Clinic,Bil_No,Remarks/Reasons,Medical_Leave,Medical_Fees) Values (" & Me.Name & "," & Me.Date & "," & Me.Clinic & "," & Me.Bil_No & "," & Me.Remarks / Reasons & "," & Me.Medical_Leave & "," & Me.Medical_Fees & ");"

Select allOpen in new window

1. Your TEXT data needs to be delimited by quotes.  (Name data should use chr(34) rather than ', to avoid errors from names like O'Malley)
2. Your DATE/TIME data needs to be delimited by hash marks (#).
3. Your NUMERIC data needs to have  NO delimiters.
4.  Special characters, like "/" should be avoided.  If you do use them, you need to enclose the field/object name in square brackets: [Remarks/Reasons]

Also, line breaks make your code easier to read and maintain:

In the code below, I'm guessing that Name, Clinic, Bil_No, Remarks/Reasons are text and that Date is date/time

CurrentDb.Execute "INSERT INTO tblMRecord2 (Name,Date,Clinic,Bil_No,Remarks/Reasons,Medical_Leave,Medical_Fees) Values ("  _
                         & chr(34) & Me.Name &  chr(34)  & "," _
                         & "#" & Me.Date & "#,"  _
                         & chr(34) & Me.Clinic & chr(34) & ","  _
                         & chr(34) &  Me.Bil_No & chr(34) &  ","  _
                         & chr(34) & Me.[Remarks/Reasons]  & chr(34)  & "," _
                         & Me.Medical_Leave & ","  _
                         & Me.Medical_Fees & ");"

Select allOpen in new window

as a side comment, to help troubleshoot doing SQL like this, you should do it like this:

Dim strSQL as string

strSQL = "INSERT INTO tblMRecord2 (Name,Date,Clinic,Bil_No,Remarks/Reasons,Medical_Leave,Medical_Fees) Values ("  _
                         & chr(34) & Me.Name &  chr(34)  & "," _
                         & "#" & Me.Date & "#,"  _
                         & chr(34) & Me.Clinic & chr(34) & ","  _
                         & chr(34) &  Me.Bil_No & chr(34) &  ","  _
                         & chr(34) & Me.[Remarks/Reasons]  & chr(34)  & "," _
                         & Me.Medical_Leave & ","  _
                         & Me.Medical_Fees & ");"

CurrentDB().execute strSQL, dbFailOnError

  While it's some extra overhead, in doing it this way you can put a break point or add a stop after the "strSQL ="  statement and inspect the SQL that will be executed before it is. That really helps in debugging a bad SQL statement.

Jim.