deleting all records

[knaya]

on a click of a button from a form, i'm trying to delete all rows in a table.. i'm using: DELETE FROM tbldumptable (the table name is dumptable) but after i click the button it keeps saying compile error, systax error. . can someone please tell me what i'm doing wrong?????? Thanksss

 

[knaya]

i cnaged the code to this: DELETE dumptable.ProductId, dumptable.ProductName, dumptable.Price
FROM dumptable;
and its still giving me a syntax error..helppp

 

[knaya]

i figured it out, i did a delete macro (set system warnings off) and attached it to the "on exit" event of a form..yeeehaaaaaa