Why a record with "Error" value in all fields?

[Guest]

My database is supported by some VB codes. Recently, I can't run my codes,
because of a strange record with "Error" value in all fields. I don't know
how it appeared. If I open that table directly, an warning message "Invalid
arguments!" will pop up. What operation leads to this strange record? What
should I do?
Thanks in advance!

 

[tina]

sounds like a corrupted record in the table. suggest you try deleting the
record. if you can't, try creating a new, blank table and appending all the
records from the problem table into the new one - *except* for the corrupt
record. if that works, you may want to go so far as to create a new blank
database, immediately turn OFF the Name Autocorrect option, then import all
the objects from your current db into the new one - except for the problem
table. then compact/repair.

you may also want to see Tony Toews' site for information on database
corruption, at http://www.granite.ab.ca/_vti_script/search.htm0.idq

hth