For Mr. J. Staniforth

[Dark Hacker]

Thank you very much for your answer!

If you saw from the comand "Execute", the new tabWork is created, before the comand "DoCmd ...".
I can not use the SQL comand "DELETE * FROM tabWork" because the next tabWork which is created has another structure.
So, I think that is a refresh problem.
Can you give me an another answer?

Best regards,

D. H.

[preeti]

I am not Mr. J Staniforth,
but your SQL Statement is wrong. It has nothing to with the structure of the table.

To delete everything from a table you use:
DELETE FROM tablename;

In your case you would use:
DELETE FROM tabWork.

Preeti