How to Check If Two Fields are Null?

alpinegroove

Registered User.
Local time
Today, 06:05
Joined
May 4, 2011
Messages
55
I have two currency fields in a form: [Salary1] and [Salary2].
I would like VBA to take action only if both of them are null.

I know how to do this for one field:
If (IsNull(Me.[Salary1]) = False) Then

But what is the syntax for checking if both fields are null?

Thanks
 
Hi
You could try:
Code:
If (IsNull(Me.[Salary1]) = False) AND (IsNull(Me.[Salary2]) = False) Then
 
And thanks for the cross-posting etiquette info, pbaldy. I appreciate it.
 

Users who are viewing this thread

Back
Top Bottom