Database editor error message

[Paul M]

Hi
In the database editor I choose a record to be edited I
change a record press ok, but the record is not updated.
instead I recieve the following message, and Any possible
causes?

Database Results Wizard Error
The operation failed. If this continues, please contact
your server administrator.

 

[Paul M]

Hi
I found an article which said put brackets around the
timestamp field but it did not work. This is the full
error message
Database Results Wizard Error
Description: Field 'Results.Gender' cannot be a zero-
length string.
Number: -2147467259 (0x80004005)
Source: Microsoft JET Database Engine

One or more form fields were empty. You should provide
default values for all form fields that are used in the
query.

Thanks
Paul M

 

[Paul M]

I have found the answer
Paul M

 

[Andrew Murray]

so....what is the answer? I have the same problem.