I have tried to use the above code and the message box works fine but the record is not deleted afterwards. Please excuse my ignorence I am new to the world of visual basic.
I am trying to delete all the records on the form including any that might be in the sub form as well ... could that be...