469,927 Members | 1,897 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

Cascading delete not working sometimes

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! :)
Attached Images
File Type: jpg untitled.jpg (19.2 KB, 131 views)
Nov 13 '09 #1
1 1445
2,364 Expert 2GB
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:-)

Nov 22 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Doug Serie | last post: by
3 posts views Thread by Mahesh S | last post: by
6 posts views Thread by visionstate | last post: by
1 post views Thread by cesar.guinovart | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.