Form filter works in 2000-2002 but fails in 2003

  • Thread starter Thread starter Greg O
  • Start date Start date
G

Greg O

I have a client with an Access 2000 format database sitting on a shared
drive on his server. Several of his forms are filtered based upon the
current value of other open forms.

The form's filter looks like this:
[ClientNumber]= forms![client information].[policy info header
only]![ClientNumber]
And [PolicyNumber] = forms![client information].[Policy info header
only]![PolicyNumber]

Allow filters is set to Yes.

Some users have Access 2000 and some have Office XP with 2000 or 2002. The
owner has Office XP with Access 2003, and only his filtered forms will not
retrieve the data whatsoever. The rest of the database functions normally
on his machine, all queries, forms, reports, etc. Did Access have a form
reference syntax change in 2003 that would cause this?

I don't have the 2003 version here to test it on, but on my 2002 version it
runs just fine. Any help would be appreciated.



Greg Obermier
IT Consultant
Choctaw Engineering, Inc.
 
There have been other reported problems with Access 2003 not recognising
that syntax.

Try referring to the form in the subform control, i.e.:
forms![client information].[policy info header only].Form![ClientNumber]

Explanation of the ".Form" bit:
http://allenbrowne.com/casu-04.html
 
Thanks Allen. I'll have to wait till next week to try it since I'm in the
MS2274 (Server 2003) class all this week. I'll try to post back with the
results.

Greg Obermier
IT Consultant
Choctaw Engineering, Inc.


Allen Browne said:
There have been other reported problems with Access 2003 not recognising
that syntax.

Try referring to the form in the subform control, i.e.:
forms![client information].[policy info header only].Form![ClientNumber]

Explanation of the ".Form" bit:
http://allenbrowne.com/casu-04.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Greg O said:
I have a client with an Access 2000 format database sitting on a shared
drive on his server. Several of his forms are filtered based upon the
current value of other open forms.

The form's filter looks like this:
[ClientNumber]= forms![client information].[policy info header
only]![ClientNumber]
And [PolicyNumber] = forms![client information].[Policy info header
only]![PolicyNumber]

Allow filters is set to Yes.

Some users have Access 2000 and some have Office XP with 2000 or 2002.
The
owner has Office XP with Access 2003, and only his filtered forms will not
retrieve the data whatsoever. The rest of the database functions normally
on his machine, all queries, forms, reports, etc. Did Access have a form
reference syntax change in 2003 that would cause this?

I don't have the 2003 version here to test it on, but on my 2002 version
it
runs just fine. Any help would be appreciated.



Greg Obermier
IT Consultant
Choctaw Engineering, Inc.
Click to expand...
Click to expand...
 
Back
Top