Meeting Conditions BeforeUpdate

  • Thread starter Thread starter Melinda
  • Start date Start date
M

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
 
Melinda said:
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
Click to expand...

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