-
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.
-
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
