Write Conflict Error in a UI liked to Oracle

[jjz0512]

Hi, I have a form that has 5 tabbed sub forms on it and the last form is causing a Write conflict error when I try to update data for an existing record. When I update other tab forms for the same ID, it's fine, it's just this tab form, CME. The Write Conflict message, This is has been changed by another user since you started editing it. But, I'm the only one in. Now this is primarily a UI that has links to an Oracle database, but I'm the only person in the database. What's causing this?

Thanks in advance to anyone who can help me. This forum members have always provided me with help, even when it's a dump question. Thanks Again!

[rpeare]

You're using a bound form and likely the tab you are having trouble with has some piece of data in it belonging to the 'main' dataset. You'll get the error you're getting even if you're the only one in it if the 'main' record has been modified without being saved while a 'sub' record has also been changed (at least that's what has happened to me in the past).

I don't use bound forms for reasons like this. Have you tried building an unbound form?

Your other option is to force a save of the 'main' record every time you perform an action involving the subform.