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

Editing Subform Link Fields

P: n/a
Using Access 2003 SP-1.

I have a form which contains a subform. Each form represents a table,
and is linked by two fields. These fields are also related in the
underlying tables, with referential integrity and cascading updates

The problem occurs when I attempt to update one of the link fields in
the parent form. Instead of displaying the cascaded updates (i.e. not
changing), the subform will display the new results based on the link
field (usually an empty table). If I then try to change records I am
given the following message:
"Cannot perform cascading operation. There must be a related record in
table 'Produced'."

It would appear that the link is updating before the parent has a
chance to cascade its changes to its children, and is then preventing
the cascaded changes from being written to the database.

I've tried requerying and/or refreshing both the parent or child in the
AfterUpdate even of the key field. The problem persisted.

Anyone have any ideas?

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.