After a good night's sleep I realised there might be a better way to achieve what you want. I've done this video:-
Delete Tables - Nifty Access
from which you should be able to reconstruct the "DELETE TABLES FORM" yourself. Alternatively go to my website HERE:-
Delete Tables
Delete Tables There are various options for deleting tables. I will gradually build up this webpage with more options as time permits. However before you delete "ANYTHING" in your MS Access Database, make a backup first! It's amazing even the most seasoned professionals can fall foul of this...
www.niftyaccess.com
where there's a download button. You can download a WORKING example dB containing the code. For a short time, it's available for free, using the coupon code:- free_or_buy_tony-a-coffee
If you miss the opportunity to get it for free with the coupon code:- free_or_buy_tony-a-coffee THEN Contact me, and I will provide an alternative way of getting a free copy...