dbseechanges

Hi there,



Can someone help me with how to use dbSeeChanges using my code below.





Every thing was working fine with my code below until I had to use the primary key field in the sql statement.



This is my code:



Set dbs = CurrentDb

Sqlstring = "UPDATE Tbl_AZorders " & _

"SET Tbl_AZorders.Approver='" & Txt_Approver & "'," & _

"Tbl_AZorders.Comments = '" & Txt_Comments & "'," & _

"Tbl_AZorders.EquipUsed = '" & Txt_EquipUsed & "'," & _

"Tbl_AZorders.DateCompleted = '" & Txt_DateCompleted & "'," & _

"Tbl_AZorders.[Open] = 0 " & _

"Where Tbl_AZorders.WorkOrderNumber IN (" & GloSelectedWorkOrderLst & "); "



dbs.Execute Sqlstring



Thanks for any help you can give.



Best Regards,

dbseechanges