Deleting all records from a table 1

[mondeoman]

I want the user to be able to delete all records from a table by clicking a command button and bringing up a form based on the table from where I want the records deleted. I can't use a macro as the SQL is too long with the number of fields in the table. I have also tried to use the RunSql but I clearly doing something wrong. the SQL I have been using is:

DELETE tbl_Support_Request.Request_ID, tbl_Support_Request.Employee_ID, tbl_Support_Request.Caller_Surname, tbl_Support_Request.Caller_Initials, tbl_Support_Request.Site, tbl_Support_Request.Job_Purchase_Number, tbl_Support_Request.Date, tbl_Support_Request.Time, tbl_Support_Request.email, tbl_Support_Request.Telephone, tbl_Support_Request.Extension, tbl_Support_Request.Request_Type
FROM tbl_Support_Request;

Can anyone help.

 

[JerryKlmns]

How about
DELETE FROM tbl_Support_Request;