dbseechanges

[Steve2106]

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,

 

[pbaldy]

Try


dbs.Execute Sqlstring, dbSeeChanges

 

[Always_Learning]

Hi Paul,

Thanks for the info, that worked.

Best Regards,

 

[pbaldy]

Happy to help! you may also want the dbFailOnError option. More info in help on the Execute method.