Forms - Access 2000 vs. 2002

[sumoalex]

We are pair-programming using Access 2000 and 2002. We have a form that has a list box that gives different results on an Access 2000 machine versus an Access 2002 machine (Access 2000 seems to filter or limit the results inconsistently, as opposed to Access 2002 giving us all of the results.)

Has anyone come across this? We just discovered this and can't go to production on Monday with the database behaving this way.

Help!

 

[sumoalex]

To clarify... when the .mdb is used in Access 2002, it does give a message to indicate that it knows it's in "Access 2000 file format".