the database can not contain null value error

[rexrivas]

I have a form with the following fields: Name, location, date.All are required fields.

Location properties include row source type = Table/Query and limited to list . I created another subform for the user to create a new location via add new record. but i ocasionally get "the database can not contain null value" error.

How can i avoid this error?

 

[rexrivas]

Revised...

I have a form with the following fields: Name, location, date.All are required fields.

Location properties include row source type = Table/Query and limited to list . I created another subform for the user to create a new location via a macro tha twill close the form and launch the subform. THe subform has a button to closew the subform and return to a refreshed original form, but i ocasionally get "the database can not contain null value" error.

How can i avoid this error?