I've checked the forum but can't fand an answer to my particular problem. I'm getting this error on the following line of code:

If (DCount("*", "qryEmployeeAvailability") = 0) Then

I use this syntax throughout most of my db and don't get any problems. I've tried importing all items into a new db but still get the same problem.

Any idea what is causing it?

I believe it should be this:

If DCount("*", "qryEmployeeAvailability", "[YourfieldNameHere]=0") Then