Hi smh,

NO NO NO - NEVER USE NULL - Ed, you must be cast into the everlasting flames of Nullity...

To be a bit more helpful, put

Code:
If IsNull(Me.cboBankName.Text) Then
  rst("bankname") = "Missing"
Else
  rs("bankname") = Me.cboBankName.Text
End If
I would test the value of cboBankName.Text explicitly for Nullity and see whether the value is getting returned properly.

Cheers,

P.