Parent Update from Subform in ADP Causes Write Conflict

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robert Robichaud - 10 Aug 2005 04:19 GMT

When the Quantity field in the subform is changed, the Quantity_AfterUpdate
has the following line:

Me.Parent!QuantityChanged = True

When I click on the form's tab to change the focus to the Parent, the Write
Conflict message appears.

QuantityChanged is set up in SQL Server as:

Data Type: bit
Length: 1
Allow Nulls: NOT CHECKED
Default Value: 0

Any ideas on what's happening or where I should be looking? Any comments
are appreciated.

Reply to this Message

giorgio rancati - 10 Aug 2005 19:43 GMT

Hi, Robert

put the *Me.Parent!QuantityChanged = True* in Form_AfterUpdate event.

example
----
Option Compare Database
Option Explicit
Dim CheckQuantityChanged As Boolean

Private Sub Form_AfterUpdate()

If CheckQuantityChanged = True Then
Me.Parent!QuantityChanged = True
End If

CheckQuantityChanged = False

End Sub

Private Sub Quantity_AfterUpdate()

CheckQuantityChanged = True

End Sub
----

Ciao Giorgio

> When the Quantity field in the subform is changed, the Quantity_AfterUpdate
> has the following line:
[quoted text clipped - 13 lines]
> Any ideas on what's happening or where I should be looking? Any comments
> are appreciated.

Reply to this Message

Robert Robichaud - 10 Aug 2005 22:48 GMT

Giorgio,

It worked! Should have posted this last week instead of pulling my hair
out!

Once again, Thank You!

Cheers,

Robert

> Hi, Robert
>
[quoted text clipped - 44 lines]
>> Any ideas on what's happening or where I should be looking? Any comments
>> are appreciated.

Reply to this Message