By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,928 Members | 1,810 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,928 IT Pros & Developers. It's quick & easy.

Cascading delete not working sometimes

P: 29
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, 117 views)
Nov 13 '09 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 2,364
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.