I have created a MsAccess database on my work laptop using Access 2003. The database was saved in Access 2000 file format. I have copied the databse to my work desktop which runs Access 2000. The database loads Ok, but a lot of the macros and VBA code that creates default values for fields and does lookups does not appear to work. I have drawn a blank on knowledgebase. What might be causing this problem? Is there a different VBA syntax required for Access 2000? There are no errors reported. Its just that the default values (e.g. automatically generated dates) and iif routines simply dont work.