form causes crash of Access 2003

[Guest]

I have a form which has a subform which in turn has a subform. When I use a
drop down control to search for a record on the main form, the program finds
the record and updates the subforms but crashes before it updates the main
form. If I step through my code it doesn't happen nor does it happen if I
use Access XP. This problem just started happening. Is there anything I can
do to fix this? Thanks.

 

[Granny Spitz via AccessMonster.com]

If I step through my code it doesn't happen nor does it happen if I
use Access XP. This problem just started happening. Is there anything I can
do to fix this?

Make sure the code is still compiled and make sure no one else is sharing
this file. If you have multiple users, the database needs to be split, with
the tables and relationships in the backend on the server, and a copy of the
front end with all other objects on each person's own computer.