Required Fields on a Form entry

[lr999]

Hello

I need to make 'script#' and "script developer' required fields on script form. I used the following code:

Private Sub Form_Close()

If IsNull(Me.Script#) Or Me!Script# = "" Then
Me!Mes.Caption = "Script# Can Not be Blank"
Me!Script#.SetFocus
valFields = False

If IsNull(Me.ScriptDeveloper) Or Me!ScriptDeveloper = "" Then
Me!Mes.Caption = "Script Developer Can Not be Blank"
Me!ScriptDeveloper.SetFocus
valFields = False
End If
End Sub

 

[dhookom]

Is there a problen you could tell us about? What are your results? IMO, the "#" and other symbols should never be used in object names. Did you try wrap you unorthodox names in []s?

If IsNull(Me.[Script#]) Or Me![Script#] = "" Then

Duane
Hook'D on Access
MS Access MVP