Access 2002 form crashes silently in 2000

[davedoop]

Anyone have an idea why my Access 2002 form crashes Access silently when I open it in Access 2000? I have DAO 3.6 reference set and use either currentdb.openrecordset or me.recordset to open recordsets. Also, curiously, my navigation buttons act wierd in 2000. They use the docmd.GoToRecord function but recordset.AbsolutePosition and recordset.RecordCount do not report the correct numbers - they works perfectly in 2002, however. Any ideas on this would be greatly appretiated.

Thanks, Dave

 

[RoyVidar]

Think I'd like to take a peak at the code that's erroring (and if available, also the errormessage), what happens when you step thru the code?

I'd perhaps use the recordsetclone in stead of the recordset. For instance try using the recordsetclone for recordcount (should also be able to get the recordcount by using the controlsource of =Sum(*) or =Sum(YourIdField)), and in stead of the absoluteposition on form recordset, try using Me.CurrentRecord.

Roy-Vidar

 

[davedoop]

Great! Apparently Access 2000 tries to recompile Access 2002 code upon opening. I had some leftover junk code and after I removed it, the application opened cleanly.

Also, the me.currentRecord tip did the trick.

Thanks a million!!!

Now, on to the next bug...