Add don't Allow Nulls

[Dan @BCBS]

My Access 2000 linked to SQL db's.

This databes has been used for years. I was asked to make another field
manditory. I went to the SQL table and unclicked the Allow Nulls, refreshed
the db and then relinked the table in Access.

Nothing happen, the user can still close the form without entering a value..

What am I missing????

 

[Ofer Cohen]

Add to the form BeforeUpdate event a validation, that check that field and
prompt a proper message a stop the Propcess

If IsNull(Me.[TextBoxName]) Then
MsgBox "Value must be enterd in.."
Cancel=True 'Stop the process
End If

About the table, check if it has a default value defined