Yikes. So what sort of relationships are there on tblOpvAlarmen that might prevent the query from running? I see it is joining on tblCodesAlarmen. Did you want to delete from the tblCodes table?





mmcdonal

The data that has to be deleted comes from the table 'tblOpvAlarmen'.

This table has the fields 'volgnummer', 'datum', 'uur', 'code alarm', 'naam agent', 'naam personeelslid' and 'reden alarm'.

The 'code alarm' field is linked to another table called 'tblCodesAlarmen' that has the fields 'code alarm' and 'omschrijving alarm'.

The 'tblCodesAlarmen' is on the one side of the relationship. 'tblOpvAlarmen' is on the many side of the relationship...

The 'tblCodesAlarmen' is used to store the data as unique values and makes me able to limit the values by using a combo box. I'm using a table because the data could evolve in the future...