How to do I clear a table after sending it

F

fifi

Hello Everybody,
I have a command button that let me submit a table when clicked. Now I
want the table to be cleared after that. Can somebody please tell me how to
do that?
Thank you for your help
 
T

tina

well, i've no idea what you mean by "submit a table". but if you're asking
how to delete all the records from an Access table, use a Delete query.

hth
 
K

Klatuu

You don't need to write and store a query for this. Just do this:
CurrentDB.Execute("DELETE * FROM MyTableName;")
 
Top