I'm totally confused as to what is happening with this error message.
Of the 4 data tables inside an Access 2000 database, only one table will not allow me to go through an EDIT screen and save it. I get the following error message:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The field 'Budget.LineItem' cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field.
/MG Web Applications/Budget_edit.asp, line 460
LINE 460 IS: rs.Update
First off, YES, all the items are being entered. I can add new data to this table, just cannot edit and then save it. I have all the permissions set for this database. Again, it's only this one table that creates this error message when saving from the EDIT screen.
If I use the ADD screen, I can save it, but if I go right back in as an EDIT and do nothing at all (all data remaining the same) and then click on save; I get that error message.
Here's the table layout:
Name Type Size
BudgetID Long Integer 4
TeacherID Long Integer 4
SchoolID Long Integer 4
ApplicationID Long Integer 4
LineItem Text 100
Supplier Text 75
Quantity Long Integer 4
UnitCost Currency 8
TotalCost Currency 8
Submitted Yes/No 1
Any suggestions???
Thank you in advance for any help! It's greatly appreciated!!!
