Can;t get Workdays function to work

[khughes46]

Granted I am new at trying to use VBA but I followed the instructions explicitly when copying the code into a module. I don't know if I didn't name it correctly or what, but I got a clean compile. However when I try to use the Workdays function I get an error "Undefined function Workdays in expression. What have I done wrong? File attached.

[RuralGuy]

Do the Function and the Module have DIFFERENT names? They should and it's important.

[khughes46]

They do now, the function is Workdays and the module is Work_Days.

[RuralGuy]

That should have resolved your issue. Did It?

[June7]

The names are different. You are calling the Workdays module and not the Weekdays() function in the query. Change WorkDays( to Weekdays(.

I REALLY find query input popups annoying. Better to use reference to controls on form as input. Even better is no dynamic parameters in query at all (I don't use them). I use code to apply filter criteria to form or report when they open.

[khughes46]

That did it. Thanks.