=DCount("[Report Number]","[qSTATS1]","[TA]='Engineering'And[Lab Section]=Electronics'")

I put this in the Control Source in a Textbox like previously suggested instead of a macro, and it is giving me an error within the text box. It is supposed to pull from a query.

CodePudding user response：

You're missing an apostrophe in front of the word Electronics.

Try this:

=DCount("[Report Number]","[qSTATS1]","[TA]='Engineering' And [Lab Section]='Electronics'")

CodePudding user response：

Opening up the VBA and running the macro through that module fixed the issue.