I have created a form using Access 2000. I declare a public variable
Public lngStartDate as long
I set the variable to 20070101.
I then open a subform based on a query. The criteria for the query is ...WHERE iDate = Forms!frmMyForm.lngStartDate.
The form opens fine and I get the expected data in 2000.
My problem is that when I do the same thing using Access 2003, I am prompted for Forms!frmMyForm.lngStartDate when the form opens.
Any help would be appreciated.
Public lngStartDate as long
I set the variable to 20070101.
I then open a subform based on a query. The criteria for the query is ...WHERE iDate = Forms!frmMyForm.lngStartDate.
The form opens fine and I get the expected data in 2000.
My problem is that when I do the same thing using Access 2003, I am prompted for Forms!frmMyForm.lngStartDate when the form opens.
Any help would be appreciated.
