3101 error on nearly all fields in form?

[Guest]

I'm getting the following error:

"The Microsoft Jet database engine can't find a record in the table <table
name> with key matching field(s) <field name>"

None of the fields in question are required, and it occurs on fields when I
don't even make an entry for them in the form. If I make an entry, it just
gives the same error message on another form.

Any help?

Thanks,
CW

 

[Guest]

Correction: If I make an entry, it just gives the error message for another
control (field).

CW

 

[Tony Toews]

I'm getting the following error:

"The Microsoft Jet database engine can't find a record in the table <table
name> with key matching field(s) <field name>"

None of the fields in question are required, and it occurs on fields when I
don't even make an entry for them in the form. If I make an entry, it just
gives the same error message on another form.

This sounds rather weird. And may be some interesting corruption but
I'm just guessing.

Is there any code behind the form?

If you feel comfortable doing so please zip and email me your MDB to
tony at granite dot ab dot ca.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Guest]

Tony,

Thanks for the reply and sorry I didn't respond earlier. Just in case you
still check this thread, I'll respond now even though it's well after the
fact.

Apparently, the problem was with the way I had set up cascading in the
relationships window of my db. For some reason, I had taken a "wait and
see" approach on which options to check in the relationship cascading
section, and I guess I DID see!

After much wasted time and headache, I made the necessary changes and all is
well.

Thanks again, and sorry for the delay.
CW