Button on Form to Clear All Table Records

[leladavis]

Can someone please suggest the VBA code to use on a button in a form that would delete all the records from a table called "tbl_FMC_List"?

I am the only person using this form so I just want to click the button and clear all the records from the table.

 

[JANR]

Currentdb.Execute "Delete * From tbl_FMC_List", dbFailOnError

will remove all records, perhaps you should give your self a chance to stop deleting with a msgbox in case you accedently click on your button

JR

 

[leladavis]

Thanks so much for the fast reply. That worked perfect!