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
Function ParmValue() As Date
ParmValue = InputBox("date here")
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?