code for “do nothing” 3

[tech12345]

Code for “Do nothing”

Is there any VBA code for “do nothing”
As an example, there is no VBA function for Is Not Null
so to carry out an action if a field is Not null

If IsNull(Fieldname) then
‘do nothing
Else DoCmd.OpenForm “Formname”
End If

This works fine with leaving the first statements blank, but doesn’t seem right???

Any observations/suggestions would be gratefully received

 

[Rolliee]

The way to do this is:


Okay = not IsNull(MyVariable)


Rollie E

 

[CajunCenturion]

Either of the following three contructs are valid, but, from a style standpoint, I prefer the second:
1)

If IsNull(Fieldname) then
Else
   DoCmd.OpenForm “Formname”
End If

2)

If Not IsNull(Fieldname) Then
   DoCmd.OpenForm "Formname"
End If

3)

If Not IsNull(Fieldname) Then DoCmd.OpenForm "Formname"

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[tech12345]

Thanks to Both,
Thats me sorted