Problem between public var Access 2000 and 2003

[wjburke2]

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.

[DonRayner]

Change Forms!frmMyForm.IngStartDate to
Forms!frmMyForm!IngStartDate

[NeoPa]

This is a nuisance (as far as I'm concerned) and is related to changes between the versions. What was working ok, no longer does.

To get around this I use a public function to return any values I need. The variable can go back to being declared as Private. Clearly, when multiple values are required, a Select statement is a sensible solution within the function.