Required Fields on Access Form

[mizenerman]

Please excuse my newbie ignorance but this one I'm sure is simple but I have no idea were to begin.

There is a field on a form that is called the MRN field. If the field is NULL then I want a message box to appear stating "MRN field is required". I'm unsure if a macro is the best approach??

Any guidance is much appreciated.

 

[Remou]

The best thing to do is to use the Before Update event for the MRN control.

 

[mizenerman]

Thanks Remou. Now, if I may trouble you again I'm having an issue with my code. This is what I have entered as an event procudure in the Before Update:

Private Sub MRN_BeforeUpdate(Cancel As Integer)
If IsNull(Me!MRN) Then
Cancel = True
MsgBox "MRN is required."
Me!MRN.SetFocus
End If
End Sub

Where could it be that I'm failing? Thank you once again.

 

[Remou]

You do not need this line:

[tt]Me!MRN.SetFocus[/tt]

 

[PHV]

I'd use this test:
Private Sub MRN_BeforeUpdate(Cancel As Integer)
If Trim(Me!MRN & "") = "" Then
MsgBox "MRN is required."
Cancel = True
End If
End Sub

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[scottian]

Also, if the MRN is a constant length, you may want to also check the length is correct.

Its not who you are that defines you, its what you do...

 

[mizenerman]

Thanks PHV! That worked perfectly. Also, thank you all for your input. Most helpful!!