Why does this sql not work?
It brings up the records which satisfy the criteria if one clicks on the view button. Yet does not delete the records! No warning signs appear at all
DELETE pupils.*, pupils.[Pupil ID]
FROM pupils
WHERE (((pupils.[Pupil ID])=[Forms]![Parents]![cmboPupilsDelete]));
Any ideas?
Thanks
It brings up the records which satisfy the criteria if one clicks on the view button. Yet does not delete the records! No warning signs appear at all
DELETE pupils.*, pupils.[Pupil ID]
FROM pupils
WHERE (((pupils.[Pupil ID])=[Forms]![Parents]![cmboPupilsDelete]));
Any ideas?
Thanks