467,886 Members | 1,824 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,886 developers. It's quick & easy.

Access 2003: Forms!MainForm!Subform!Control problem

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
  • viewed: 2089
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by Mike MacSween | last post: by
64 posts views Thread by John | last post: by
3 posts views Thread by Malcolm Webb | last post: by
49 posts views Thread by Mell via AccessMonster.com | last post: by
17 posts views Thread by Mell via AccessMonster.com | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.