Update query problem

[hedgracer]

I have the following vba update query:

strSQLB = "UPDATE Exch_Designation_List SET Broker_Number = " & cboBrokerNumber & " , Firm = '" & sFirm & "' ,Office = '" & txtOffice & "' , Sales_Series = 'XXXXX', Account_Number = 'XXXXX';"
MsgBox strSQLB
DoCmd.RunSQL strSQLB

The query is not updating the table. Can anyone qive me some suggestions on what might be going wrong? Thanks.

dave

 

[Golom]

Since your SQL doesn't have any constraints defined (i.e. there's no WHERE clause,) this will attempt to update every record in the table.

If one of the fields is (or is part of) the primary key then attempting to change it to a constant value will cause duplicate key problems. Also, if the fields in this table are foreign keys into another table then you may be raising foreign key violations if that value doesn't exist in the other table.