I am trying to update a record in a SQL database.
This is a snip of my code:

With rst
.Update

rst("bankname") = cboBankName.Text
rst("address1") = txtBankAddress1

.Update
End With

I used the exact code in another program that I have made and it worked just fine. Now, when I get to the second ".Update", it says that I can't enter a NULL value into the field "bankname". When I run the program, there is data stored in 'cboBankName.Text' and all the other textboxes. Where am I going wrong?

(I used an Access database with the other project. Could I be getting an error because I am using SQL?)