Delete Record 1

[ecugrad]

Question, I want to code a delete button to delete selected records from a subform. The records reside in a table called tblResults. When I use a cmdButton I get record cannot be deleted because it contains a related record in the tblResults table. This is the table I want to delete the record from. I guess it is looking and trying to delete from my tblEmployees table, which is the one to my one to many relationship. The record deletes fine if I highlight it and push delete on the keyboard.

Hoe do I mimic the code Access uses when the delete is used from a keyboard.

Thanks in advance..

 

[jgoodman00]

You should be able to use a DoCmd.RunSQL combined with a DELETE FROM SQL statement

e.g.

DoCmd.RunSQL "DELETE FROM tblResults WHERE PrimKey = " & [ReferencePrimKey] James Goodman

http://www.james-goodman.co.uk