Error message

[kim40]

I have this code and it is giving this error Compile Error sub or function not defined this is the code
Select Case Me.lstSalesPeriod
Case ByYear
strReportName = "Customer Reports"
lOrderCount = DCountWrapper("*", "Order Analysis", "[Year]=" & Me.cbYear)
Case ByMonth
strReportName = "Customer Reports"
lOrderCount = DCountWrapper("*", "Order Analysis", "[Year]=" & Me.cbYear & " AND [Month]=" & Me.cbMonth)
End Select
Me.cbYear) this is where the error has been identified

thanks

 

[pbaldy]

Presumably there is a control with that name? Is DCountWrapper a public function in a standard module? It isn't a built in function.

 

[kim40]

This has helped greatly thanks

 

[pbaldy]

No problema.