Write Conflict in Combo Box Update

  • Thread starter Thread starter harpalshergill
  • Start date Start date
H

harpalshergill

Hi i have to SQL tables which i linked to the access.

now in my form i have a combo box to look up the details of PK of other
table.

there is a message of write conflict which i tried to change the value
of the combobox, i tries the same thing in other sub forms and it work
fines at there...


do u know what is the problem

thanks in advance
 
Hi,



A possible scenario, not necessary your case, is that your VBA code try to
update the record you actually see, but that record is dirty and is either
actually locked, either Jet will find that someone else than you (which is
your VBA code) changed the record while you were editing it, when you try to
save it.


A possible solution is to save the record:

Me.Dirty=false

then, and only then, do the combo update thing.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top