Meeting Conditions BeforeUpdate

[Melinda]

Hello,
I have a form that has 3 required fields. I wrote a
macro using Access's Macro Builder to have message boxes
pop-up if the fields are null. I would now like the
macro to take place on the BeforeUpdate event, but I have
an event procedure there. I'm not much of a programmer
yet, so how does one tell VB to display a message box if,
for example, JobCode is null?
Thanks!
Melinda

 

[Rick Brandt]

Hello,
I have a form that has 3 required fields. I wrote a
macro using Access's Macro Builder to have message boxes
pop-up if the fields are null. I would now like the
macro to take place on the BeforeUpdate event, but I have
an event procedure there. I'm not much of a programmer
yet, so how does one tell VB to display a message box if,
for example, JobCode is null?
Thanks!
Melinda

If IsNull(Me.ControlName) Then
MsgBox blah blah
End If

 

[Melinda]

If IsNull(Me.ControlName) Then
MsgBox blah blah
End If

Thank you very much Rick! I was having trouble with the
IsNull!