[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.

[brucevde]

You tried to add a new Employee Record but did not specify the password. As the error states the password is required and cannot be Null.

[lilmark]

You tried to add a new Employee Record but did not specify the password. As the error states the password is required and cannot be Null.

I hate the obvious.
I was trying to edit a current record. I didn't mean to add a new one.
To edit I would only to delete the .addnew from my current coding, right? Or is there some edit coding I need to include?

[si_the_geek]

You were right, for ADO nothing is needed - an edit is implied as soon as you set/change values.

(for DAO you need to specify an edit)

[dee-u]

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...



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.

Remove the .AddNew if you only want to update...