Requery work in Access 07 but not in Access 03??

[Sunny Ho]

I have constructed a db using MS 2007 with file type mdb (2002-2003) file
format.
Inside the db, I have a form with a "list" combined with a "combo box", when
I change select the item on the combo box, the record showed in the "list"
would be changed.

It works in Access 07 by using the "requery" macro in the "after update"
attribute of the "combo box".

But when I open the mdb file in the machine using Access 03-SP3, the requery
appeared not working.

Is requery not supported in access 03-sp3??

Thanks for the expert help~~~

 

[Jeanette Cunningham]

If you want your database to work in both A2003 and A2007,
build the database in A2003.

Newer versions of software have new features which are missing from the
previous version.
A2007 has new ways with macros (embedded macros), which will probably not
work in A2003.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia