Input Parameters

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



On some forms, the information that comes up is year specific.

I have a function in the main module to return the year they are currently
using.
It works 100% until we swapped to the adp. It worked with the mdb so this is
not the problem.

the function is called getWorkingYear()

In the form the control source is a query with "year" set with criteria of
[aYear]. Everytime I go to the input parameters I can never get it go say
anything but

? = aYear

I would love for it to say aYear = getWorkingYear()

Suggestions?

.



Relevant Pages

  • Re: Input Parameters
    ... [aYear]. ... Everytime I go to the input parameters I can never get it go say ... I would love for it to say aYear = getWorkingYear() ...
    (microsoft.public.access.adp.sqlserver)
  • RE: Input Parameters
    ... "Deburner" wrote: ... [aYear]. ... Everytime I go to the input parameters I can never get it go say ... I would love for it to say aYear = getWorkingYear() ...
    (microsoft.public.access.adp.sqlserver)