The problem could be caused by several things, such as a corrupted index,
Name AutoCorrect bugs, corrupted form, corrupted code, or an Access bug.
Try this sequence for starters:
1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html
2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact
3. Close Access. Make a backup copy of the file. Decompile 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"
4. Open Access, and compact again.
If the problem still exists, does this form happen to have a subform that is
based on a query? If so, post a reply for specific instructions dealing with
that.
We assume you have up-to-date service packs for Office XP and JET 4. If you
are not sure, check:
http://support.microsoft.com/gp/sp
http://support.microsoft.com/kb/239114