Null=Null ??

[marcuscoker]

Hi I was wondering if anybody could help me with this?

I have the following code on an on click event for a button

If Me.practicecheck.Value Is Null And Me.rolecheck.Value Is Null Then
DoCmd.OpenForm "filtered results no role no practice"
End If

but I get the debug box pop up, and when I go into debug and put my mouse over the code I get null = null

The values that I am trying to evaluate are in hidden textboxes on a form that take numeric values from a dropdown box

Thanks

Marcus

 

[Bat17]

Try
If Is Null(Me.practicecheck.Value) And Is Null(Me.rolecheck.Value) Then

HTH

Peter

 

[marcuscoker]

Thanks

that fixed it