XP to 2003 - form based criterion not being accepted

[Craig Bourne]

Note, This has worked for years and isn't working under access 2003



Upgrade of Access XP to Access 2003. After installing the upgrade and
Updates I'm having trouble. Form based criterion Entering



"you entered and expression that has an invalid reference to the property
Visible"



The property may not exist or may not apply to the object you specified



Action Failed

Macro Name

By_mach.ok

Condition

True

Action Name

Setvalue

Arguments

[visible], No



This functionality is used when entering criterion from a form to create a
report. The entry form is called from a switchboard and utilizes a combo box
and a field set to reference info for the query. The underlying query
generates the data for the report. In all cases I used this Macro - form -
query- report these errors occur. This has worked fine through all version
of access over the past 6 years and is no longer working. Please advise.



PS

I have applied latest Jet patch and all latest SP for windows and office.

 

[Allen Browne]

Craig, it looks like you have not received an answer to your question.

This should not break. If your combo is actually in a subform, so the
reference is something like this:
[Forms].[MyForm].[MySubform].[MyCombo]
try:
[Forms].[MyForm].[MySubform].[Form].[MyCombo]
The ".Form" bit is the correct way to refer to the form in a subform
control, and there are reports of this breaking on conversion.

If that is not the issue, it may be a corruption related to Name
AutoCorrect. See:
http://members.iinet.net.au/~allenbrowne/bug-03.html