i need help on my report

katabullet

Registered User.
Local time
Today, 09:25
Joined
Jul 1, 2013
Messages
15
hello, 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?
 

Users who are viewing this thread

Back
Top Bottom