A
Anne
Hi,
I am developing an adp database (access 2003) with a sql back end
(2000).
One of my form has a list of clients and a client subform.
When a client is selected in the list, it is displayed in the subform
as the first record.
To display the client as 1st record in the subform, I update a field
(displaySel) in the client table using:
CN.Execute "UPDATE tblClient SET DisplaySel=1 WHERE ClientID="&
me.ClientID
In the subform, the recordsource sort the client table on the
DisplaySel field Descending order.
If the user select a client, then update the client subform,
everything works fine. however if the user select a client in the
list, then select another client, I get the Write conflict error.
Any idea how I could remove this message?
Thank you in advance for your help.
Anne
I am developing an adp database (access 2003) with a sql back end
(2000).
One of my form has a list of clients and a client subform.
When a client is selected in the list, it is displayed in the subform
as the first record.
To display the client as 1st record in the subform, I update a field
(displaySel) in the client table using:
CN.Execute "UPDATE tblClient SET DisplaySel=1 WHERE ClientID="&
me.ClientID
In the subform, the recordsource sort the client table on the
DisplaySel field Descending order.
If the user select a client, then update the client subform,
everything works fine. however if the user select a client in the
list, then select another client, I get the Write conflict error.
Any idea how I could remove this message?
Thank you in advance for your help.
Anne