delete query (1 Viewer)

I'm sure i'm doing something very dumb!
I'm trying to create a delete query that deletes operators, [op name] and all their records from [train_tbl], when they are ticked as "left team" in the form [operator details].
I have spent all weekend on this, so any assistance would be very, very grateful.
Thanks

Forgot to mention, the attached database has to opened using Ctrl+Enter as it is an extract of an ongoing database.
Thanks

why does it matter? you can filter out the 'left' operators in any query. And once deleted, if you every wanted to know how many people went on a training course, you'll never know, and pray no one doesn't click 'yes they are sure' in error.

but your basic code would be

currentdb.execute "DELETE * FROM train_tbl WHERE [Employee number] =" & me.[Employee number]

Your db has a number of basic flaws - spaces in field names, repeating data (op name repeated in train_tbl. relationships not defined, repeated horizontal column headings (i.e. is excel style, should be vertical - Sun, Mon etc in operators), numbers stored as text.

CJ_London, thanks for your reply. I will look at it again and try using a simple query, never thought of that! I know there are some basic flaws in the design, this is due to being a novice at access and building it "as I go".
Thanks

CJ_London, thanks for your help, a simple select query did the job. I should try and remember to look for the simple solution, not over complicate things!