Insert into table, Only if i change table name, Why?

[pritesharyan]

here is my project
now i try to insert data into Order table using click event
of button on Main form in my project.
in my project i have order form and order table.


i can only insert data if i change my table name to
order1.
i don't want to change talbe name
any solution??
Below is my Click event code.

Private Sub Command127_Click()
    
    Dim StrSQL As String
    Dim InDate As String
     
     
    InDate = Format(Date, "dd-MM-yyyy")
   
     'this doesn't work because i think may be form name and table name are same
     'what shoul i have to do?? i don't want to change table name.
     StrSQL = " INSERT INTO Order1([CustomerID],[EmployeeID],[OrderDate],[RequiredDate],[FinishedDate],[Tax],[OtherAmount],[Diary],[Note],[LastEditDate]) VALUES (1,1,#" & InDate & "#,#" & InDate & "#,#" & InDate & "#,10,450,'Diary','Note',#" & InDate & "#)"
  
    'It works if i change table name to Order1
     'StrSQL = " INSERT INTO Order1([CustomerID],[EmployeeID],[OrderDate],[RequiredDate],[FinishedDate],[Tax],[OtherAmount],[Diary],[Note],[LastEditDate]) VALUES (1,1,#" & InDate & "#,#" & InDate & "#,#" & InDate & "#,10,450,'Diary','Note',#" & InDate & "#)"
    
    DoCmd.SetWarnings False
    DoCmd.RunSQL StrSQL
    DoCmd.SetWarnings True
    
End Sub

[pritesharyan]

I have just googling and found that just write table name in squre bracket and it works. see below query
StrSQL = " INSERT INTO [Order]([CustomerID],[EmployeeID],[OrderDate],[RequiredDate],[FinishedDate],[Tax],[OtherAmount],[Diary],[Note],[LastEditDate]) VALUES (1,1,#" & InDate & "#,#" & InDate & "#,#" & InDate & "#,10,450,'Diary','Note',#" & InDate & "#)"
Sorry for disturbing all friends with stupid question.

[CJ_London]

the reason you are having a problem is that 'order' is a reserved word - for example it is used in SQL in ORDER BY.

putting it into square brackets will often solve the problem but will not always do so. It is strongly recommended you change the name to something else

here is a list of reserved words

https://support.office.com/en-za/art...7-da237c63eabe

[pritesharyan]

Oh i see.
Thank you so much for replying its vital information for me.