Dear Exper,
Getting error with this code, Please help me.
Thanks
Mir
Getting error with this code, Please help me.
Code:
Dim db As DAO.Database, sSQL As String
Set db = CurrentDb()
sSQL = "UPDATE [Dive Crew]" _
& "Set [Dive Crew].InitInvConf = -1" _
& "WHERE [Dive Crew].InvoiceNumber = [Forms]![frmInvoice]![cboInv];"
db.Execute sSQL, dbSeeChanges
Thanks
Mir