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.
.Fields("fldEmpGender") = cmbGender.Text
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.
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.
After I hit 'OK' it highlights the .Update line in yellow.