By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,656 Members | 920 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,656 IT Pros & Developers. It's quick & easy.

Access 2003: Forms!MainForm!Subform!Control problem

P: n/a
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
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.