Form to delete out data (1 Viewer)

[RUDOLFSUN]

Hi Im really new to VBA and forms, and I need some help creating a form that deletes out all the data from two tables.

Each fortnight I have to fill these two tables with thousands of records, I then have to delete out all the data.

Is there any way I can create a tool that I just choose the tables and select the fields I want to delete, and then hit go?

 

[Mile-O]

Each fortnight I have to fill these two tables with thousands of records, I then have to delete out all the data.

Just reading that, I got alarm bells ringing in my head. Why do you have to delete data on a fortnightly basis? Surely that goes against the point of having a database in the first place?