[RESOLVED]Error when updating database

[lilmark]

I'm using ADO commands, VB 6.0, and MS Office 2000

Below is the code I am using to update my database. I'm testing a single field first so it's just one line of code.

With Form2.rs
    .AddNew
        .Fields("fldEmpGender") = cmbGender.Text
    .Update
End With

When I do this I get the an error saying...

Run-time error '-bunch of numbers':

The field 'tblEmployee.fldEmpPassword' cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field.

I don't get this error. My test database only has 3 employees in it and they all have passwords already entered in the fldEmpPassword table/database.

After I hit 'OK' it highlights the .Update line in yellow.