Validation Rule

M

Michael

Hi, Im pretty new to coding in visual basic, so I think this may have an
easy solution

I am setting up a basic validation rule for a form I have designed. The code
(so far) is as follows

Private Sub btn_close_Click()
On Error GoTo Err_btn_close_Click

'VALIDATION RULES ----------------------------------------------------

If IsNull(Me![comments]) And [special_conditions] = "y" Or "Y" Then
MsgBox ("Comments cannot be null if there are special conditions")

'VALIDATION RULES ----------------------------------------------------

Else: DoCmd.Close
End If

I keep getting a type mismatch error which I am sure has to do with the "y"
or "Y" but I am not sure what

Any help would be great

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Validation rule of 1 field based on a field of another table 1
Data validation 16
Multiple Validation Rules 1
Validation rule for Combo Box 0
How can I allow hyphen (or dash) in this validation rule? 1
Validation Rule in Table 2
Validation Rules for a Control on a Form (?) 4
Validation Text 1

Top