Seeking Enlightenment

[LostnConfsed]

I created a database for event creation. The database will allow the admin user to create an event, and the standard user can update through use of the main form or run reports as needed. Various reports are set for export to excel and I have a delete event macro in case an event needs to be deleted after it has been created.

When I close out of the database I get an error stating that due to duplicates and null values I can't save a record. Now when the events are generated the dates for the deadline and completed dates are left empty, is this why I am getting this message? Is there anyway to get rid of this error message, or did I just create this wrong?

The database works fine but I just want an error free existence. Any help is appreciated.

Access 2007

 

[MarkK]

I downloaded your database and the error you describe does not occur. Are there specific steps to take to reproduce the error?

 

[SOS]

I believe the problem is combo42 on the Main Form is bound when is should not be. It should be an unbound combo box.

 

[LostnConfsed]

Thank you SOS I'll try that and see if it stops the message.