Does this form have a subform? If so, the error might be related to that.
There is a bug in Access 2002 and 2003 where it crashes when you move record
if the foreign key field of the subform is not represented by a text box in
the subform. For example, your Order form is probably bound to an Order
table, and the line items in the subform are probably coming from an
OrderDetail table. The OrderDetail table will have OrderID as a foreign key.
If the subform does not have a text box for the OrderID field, it will crash
Access under certain conditions in A2002/2003. Add the text box to the
subform. Set its Visible property to No if you wish. You can even put it in
the Form Header or Form Footer sections if you wish.
It's difficult to explain this bug, but AFAICT the reference to the field in
the LinkChildFields property of the subform is interpreted as a control if
there is a text box for the field, or as the undocumented type AccessField
if there is no control. The bug appears to be in the A2002/2003
implementation of the AccessField type or the reference to that type.
Before adding the text box, make sure your Name AutoCorrect boxes are
unchecked under:
Tools | Options | General
Explanation of why:
http://members.iinet.net.au/~allenbrowne/bug-03.html
Then compact the database.
After adding the text box, decompile a copy of the database by entering
something like this at the command prompt while Access is not running. It is
all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
This forces Access to recompile the code.
If those steps do not solve the problem, or if you have no subform on your
form, post back a reply for further suggestions.
