Problems from converting a file from Access2000 to 2003

[Guest]

I have just converted a file from Access 2000 to 2003.
A combo box that used to take values from a query (when selecting a value
in an other combo box) does not return any values any more.
I also get an annoying security worning when I start up the file. I have
checked the help file and tried to reduse the security to low but under
Tools/Macro menu I do not have an option for security.
Does anybody know how can these problems be solved?

Thanks in advance.

 

[Allen Browne]

Under:
View | Toolbars | Customize
Select Menu Bar, and click the Reset button.
Close the Customize dialog.

You should now be able to find:
Tools | Macro | Security
and set it to Low.

Info on turning off sandbox mode:
http://office.microsoft.com/assista...3&CTT=8&Origin=EC011081751033&Product=acc2003

If that does not solve the problem with the query, provide more detail of
how the query and combo interact.

 

[Guest]

Thank you very much for you reply Allen.
I have tried View|Toolbars|Customise|Options|Reset menu and tolbar usage data
but still I can not see
Tools |Macro|Security
As far as the combo box problem, I have narrowed down the problem to this:
Both combo boxes are in a subfom. The Query which I use to select the values
of the combo box
looks like this
SELECT SUBSUBT.SUBCATEGORY, SUBSUBT.SUBSUB
FROM SUBSUBT
WHERE (((SUBSUBT.SUBCATEGORY)=[forms]![Mainform]![Subform]![Combo0]));

I have found that the problem is the criteria:
[forms]![Mainform]![Subform]![Combo0]
If I put the combo0 in the main form and use the criteria:
[forms]![Mainform]![Combo0]
the system works fine. It seems that in an Access 2003 query I can not refer
to controls in subforms as we do in Access 2000.