Cascading delete not working sometimes

[CoreyReynolds]

Hello, I have attached a picture of my Access form.

Each record has a delete button beside it, pressing it deletes the record and cascades to the child records. Horray.

Except sometimes, for a reason I can't explain it doesn't work. I have to click off a record then back onto it and it will work.

I'm using the default VB code that access generates to perform the delete

"The table cannot be deleted or changed because table includes related records"

Is there some common thing that excellent programmers do to stop them selves from this issue I haven't heard of? Any ideas?

All of my tables have ref int enabled as well as cascading deleted (I didn't set cascading updates though).

I'm just stumped. Please help! :)

[Dököll]

Don't dispair CoreyReynolds, the truth is out there, thanks for posting your form for looks.

I will send over to the Access forum for added support. If you have not heard anything, add a bit of your code, perhaps passers-by may get a quick idea what is hapenning.

Sounds interesting, good luck with it:-)

Dököll