[RESOLVED] Problem with Code

[ielashi]

OK, I seem to understand the problem and it's almost fixed. I'm trying now to make an if statement for multiple database fields, I think my syntax is incorrect. Here it is:

If .Fields("ÍÖæÑ") = "ÅÌÇÒÉ" And .Fields("ÊÇÑíÎ ÇáÏÎæá") = "'" & Format(Now, "dd/mm/yy") & "'" Then
            cmdMGTHoliday.Enabled = True
        Else
            cmdMGTHoliday.Enabled = False
        End If

Any ideas about the basic syntax for the if statement above would be greatly appreciated. By the way, do all the fields in the if statement above must be in the SELECT SQL statement?