Code Notes field NOT to accept (save) notes that contain no data.

[Guest]

Hello

I have a subform on my main form which holds notes for each customer. I want
to set up the notes section so that it will not save it there is no input.

Can anyone help???

 

[John Vinson]

Hello

I have a subform on my main form which holds notes for each customer. I want
to set up the notes section so that it will not save it there is no input.

Can anyone help???

Open the form you're using as the subform in design view. View the
form's Properties; on the Events tab select the BeforeUpdate event,
and click the ... icon by it. Choose Code Builder. Edit the two lines
Access gives you by adding code between them:

Private Sub Form_BeforeUpdate(Cancel as Integer)
If Len(Me!Notes & "") = 0 Then ' did user leave notes blank?
Cancel = True ' if so, cancel the update
Me.Undo ' and erase the current subform record
End If
End Sub

John W. Vinson[MVP]