table error

[sobriskie]

I am getting an "invalid argument" error when I attempt
to go to another form. Accessing the form requires
matching the membership id on the current form.

After looking at the actual table I see the last record
as #ERROR in each of the fields. I cannot delete the
record and if I attempt to modify I still get the invalid
argument error.

Any Suggestions?

 

[Steve Schapel]

Sobriskie,

This appears to be data corruption. Back up the file, then try making a
table with the same structure as the sick one, and use an Append Query
to add all existing records, specifically selecting by applying a
criteria to the append query which will isolate the valid records. Then
delete the existing table, rename the new one as required, compact the
database, and try again.