having module function not working properly
i have a situation. i am creating a school database system, ive suddenly
stocked in the module function. i created form that register student every
year. in my query, i want the user to calculate all registered student in
each year. i succeeded in doing that using my parameter in my query date
field and a function in my vba module
Module Function ParmValue() As Date ParmValue = InputBox("date here") End
Function
Query creiterial=parmvalue()
now i want that the chosen date should be displayed on my report label
call "lblyear". the thing is i just cant call any control in my function.
why?, can anyone help me please?
No comments:
Post a Comment