Try adding a space + a double quote + an ampersand right after your AND operator.
On 1/5/07, Oluwatope Oyewamide <[EMAIL PROTECTED]> wrote:
>
> I get a syntax error with the DCount statement. I dont know whats
> wrong with it.
>
> dim x as integer
>
> x = DCount("[ccode]", "docs", "form![Subform1]![ccode]='" & form![C1]!
> [Text15]& "' AND "[amend]='-1'")
>
>
>
[Non-text portions of this message have been removed]
