Access 2003: Forms!MainForm!Subform!Control problem

[Sabine Oebbecke]

Hi Experts!

I have several forms and reports where controls get their values with
'Forms!MainForm!Control' or 'Forms!MainForm!Subform!Control' resp
'Forms!MainForm!Subform.Form!Control' which works without any problem
in Acc97, 2000 and 2002, but now in Access 2003 there seem to be a
problem with this.

A user is working with my app, and he uses an Access 2002 MDE in an
Access 2003 environment.

Example:

I have a table [Tab Numbers] where figures are listed from 1 to 100.

In a form I have a control called [Box] which gets its value from
another table via DLookup. This control correctly reflects the value
from this other table, lets say the value is '20'.

In the same form I have a subform with a combo box. When opening this
combo box, I now want it to display all numbers which are < or = 20:

SELECT [Tab Numbers].BoxNo FROM [Tab Numbers] WHERE ((([Tab
Numbers].BoxNo)<=[Forms]![Mainform]![Box]));

As I said, the above works fine in Access 97, 2000 and 2002, but now
with the Access 2002 MDE in the Access 2003 environment, the combo box
is empty although the control [Box] correctly shows the key value
'20'.

Does anyone has an idea why my 'Forms!MainForm!Subform!Control' does
not work in Access 2003.

Any idea would be greatly appreciated!

Thanks.

Sabine