i used
only works when i have clicked on verify textbox and edited it first... Have to add condition to check that field on form has not been set. how to do this?Code:Private Sub Form_BeforeUpdate(Cancel As Integer) If (IsNull([verify])) Then MsgBox ("test...") Cancel=true End If End Sub
this happens with 'pre-existing' records so setting default value to null for verify textbox dont help for older records... null is inserted for new records
That should work for new records or if a record is edited. You can check in the current event if the record being displayed needs that field filled out.