Oluwatope Oyewamide Fri, 05 Jan 2007 11:22:39 -0800
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'")