Delete all records from table

[gamble007]

Hi,
Im looking for a way to delete every records in a table, without deleting the table itself. This code would be under a command button. Any ideas?
Thanks

 

[THoey]

Create a query that does the following:

DELETE * FROM MyTable;

have the ButtonClick event run the query. Terry

 

[gamble007]

Thanks, thats exactly what i needed