Weird Access Runtime Error

[illy2k]

I have been writing databases for several years now, so I know my way around access pretty good. I have come upon a strange error though. which is confusing me to now end. I wrote a Database on my work machine which has the latest version of MS Access and SP2 for Office. I just tried to send it to another employee for them to test. Now they do not have the full version of MS Access installed on their machine, they only have the runtime version which only runs the Database. The load works fine and the first screen uses ADO to lookup some value and display them in a list box, nothing crazy, everything works fine. Now using this form, when they click a button the info in the list box is used to set the Fields a new Unbound form. And this is where the error happens. The on_load event of the form fails for some reason, and gives a msgbox which says, "Runtime error occured and the App needs to close", but the prog works fine on my machine. I am baffled. The file is a MS Access 2000 format, I tried changing it to MS Access 2002/2003 Format, and when I do that they cannot open the file because it says they do not have thje latest MS Access version. I have no idea what, why the error occurs, any ideas??

 

[WindSailor]

I have had one issue with the Access2003 runtime where I had used nested DAO recordsets.
The app would work fine on my machine but wouldn't sort correctly on the clients. It also didn't throw an error message... just the sort order wasn't correct in the final recordset... interesting...
I had to eliminate the nested recordsets and make my SQL code more definitive... Orders.FirstName, Orders.LastName etc.

The only suggestion I can immediately think of if is putting in msgbox's (numbered in sequence and staggered between lines of code) in the event that it is failing on so they could step through it and tell you where it fails... other than that... not sure...