By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,131 Members | 1,728 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,131 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.


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

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

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

Any idea would be greatly appreciated!


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.