Form error with not null field

[Gorrex]

I currently have tables with fields user and moddate to track who and when changes were made. They have are set to not null and have user and current_date as defaults in the database.

I'm trying to make data entry forms in Base to edit these, however I do not know how to get around OOo telling me that user and moddate require input.

Thanks for any help.

[voobase]

Hi there,

When you created your tables did you select those fields as "Entry required". Right click on your table and choose edit to look. Also you might end up having problems using Current_Date. Have a look at this post:
http://www.oooforum.org/forum/viewtopic.phtml?t=66727

Cheers

Voo