S
SAnjeev
Hi Experts,
First up some background:
I am developing a front end database in MS Access 2002 on
a WIN XP platform, and have saved it as a 2000 version.
The backend is access 2000 and is on a network drive. I
compiled the front end in Access 2000 converted it into
an MDE and distributed this to users with different
versions and on diffrent platforms; ie users with
1.) Access 2002 and WIN XP
2.)Access 2000 and WIN 2000
3.)Access 2000 with WIN 98
Now the problem:
I have a main form on which I have a combo box and a
command button. Users pick a value from the combo box and
hit the command button which is tied to a macro which
uses the following filter:
[TableProjectList].[Team Leader]=[Forms]![ProjectList]!
[Team_Leader]
This displays only the filtered records. Pretty simple so
far.
Now recently I discovrerd that if users with the access
2000 version (On any platform mentioned other than XP)
run the filter once, it works perfectly.But if they do it
again, picking a different value from the combo box, the
same record (i,e the first filtered record) is displayed.
the filter is not applied. This does not happen if it is
run on a WIN XP machine. SO what is the problem? I need
help urgently. \thanks
sanjeev
First up some background:
I am developing a front end database in MS Access 2002 on
a WIN XP platform, and have saved it as a 2000 version.
The backend is access 2000 and is on a network drive. I
compiled the front end in Access 2000 converted it into
an MDE and distributed this to users with different
versions and on diffrent platforms; ie users with
1.) Access 2002 and WIN XP
2.)Access 2000 and WIN 2000
3.)Access 2000 with WIN 98
Now the problem:
I have a main form on which I have a combo box and a
command button. Users pick a value from the combo box and
hit the command button which is tied to a macro which
uses the following filter:
[TableProjectList].[Team Leader]=[Forms]![ProjectList]!
[Team_Leader]
This displays only the filtered records. Pretty simple so
far.
Now recently I discovrerd that if users with the access
2000 version (On any platform mentioned other than XP)
run the filter once, it works perfectly.But if they do it
again, picking a different value from the combo box, the
same record (i,e the first filtered record) is displayed.
the filter is not applied. This does not happen if it is
run on a WIN XP machine. SO what is the problem? I need
help urgently. \thanks
sanjeev