2 simple questions

[octatyan]

a simple question

When users enter a new record and click the SAVE button, I want access to only save if lastname has been entered. What is the code to check is the lastname field has any info in it?

*** i solved my 2nd question, so I only have 1 question now.

 

[dcx693]

You need some code in your form's Before Update event that checks the status of the Lastname field, something like:

If IsNull(Trim(Me.txtLastName)) Then
  MsgBox "Lastname field not filled in"
  Cancel=True
  Me.txtLastName.SetFocus
Else
  DoCmd.RunCommand acCmdSaveRecord
End If