Type mismatch (1 Viewer)

[Gismo]

Hi All,

I have a form there 2 drop downs must populated before the save button is viable.
Both drop downs are text field.
When the fields are empty there is no problem but when the fields have been populated, i get a vb error "Type mismatch"

Code Tags Added by UG
Please use Code Tags when posting VBA Code
Please feel free to Remove this Comment
https://www.access-programmers.co.u...e-use-code-tags-when-posting-vba-code.240420/

# If IsNull(Me.CSAeMail) Or (Me.CSMeMail) Then
Me.SaveBTN.Visible = False
Else
Me.SaveBTN.Visible = True
End If
End Sub#

 

[Isaac]

Try changing it to:

If (IsNull(Me.CSAeMail)) Or (isnull(Me.CSMeMail)) Then
Me.SaveBTN.Visible = False
Else
Me.SaveBTN.Visible = True
End If
End Sub

Some of my paren's may be unnecessary, but will work. I tend to err on the side of caution with multiple boolean statements.

 

[Gasman]

You have to use ISNULL on both controls

 

[Gismo]

Try changing it to:

If (IsNull(Me.CSAeMail)) Or (isnull(Me.CSMeMail)) Then
Me.SaveBTN.Visible = False
Else
Me.SaveBTN.Visible = True
End If
End Sub

Some of my paren's may be unnecessary, but will work. I tend to err on the side of caution with multiple boolean statements.

Great stuff, makes sense, thank you

 

[Isaac]