The Microsoft database engine cannot find a record...

[jerem]

Hi,

I am using the Goods sample database from Microsoft. I don't know what I did but I suddenly get the message:

"The Microsoft Access database engine cannot find a record in the table "Customers" with key field(s) "CustomerID".

This only happens when I try to create a new Customer Order. The error message shows when the OrderDetail form opens. If I choose an existing order, the problem doesn't arise.

I have checked many threads on various forums but nothing seems to help.

Thanks in advance for your help!

 

[MStef]

Do you have a MAIN FORM and a SUBFORM ??

 

[jerem]

Yes. Linking field is ID in Orders table and OrderID in OrderDetails table

 

[MStef]

Do you try to enter a record in the SUBFORM before the MAIN FORM ??
What is your RELATIONSHIPS between these two tables ??

 

[boblarson]

make sure your sub form does not have the same table in it as the main forms record source and vice versa.

 

[jerem]

Solved at http://www.utteraccess.com/forum/Access-Database-Engine-F-t1995964.html