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

Write conflict error on subform

P: n/a
Using A2K. I've got a form for clients that has a subform that is a
cartesian product between client ID and a lookup table for types of
income. So each client has the exact same number of income type
records.

If the user changes the name of an income type for a client then I want
the change to happen automatically for all clients. I have a
one-to-many relationship set up between the client table and the lookup
table with cascading update set.

In the BeforeUpdate event of the income type, I change the record in
the lookup table to the new value. If I don't do this, I get an error
message that a related record is required in the lookup table when
leaving the row. But I get a write conflict error when trying to leave
the row on the subform.

I'll post code on request. Any help or advice is appreciated.

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.