"Cannot add or change a record": help please!

S

scubadiver

The tables are as follows:

tble_query -.> 1:n -> tble_CCode <- n:1 <- lkup_CCodeS <- n:1 <- lkup_CCodeT

I have a form that holds "query" information and a subform that holds
"CCode" information. Within this subform I have a cascading combo that uses
"CCodeT" and "CCodeS" as the source information.

I have all the information I need are in the look-up tables and the combo's
work fine. If I choose from the list in the first combo, I can delete the
record, but if I choose from the second combo I get the above error.

The master and child link properties are fine so I don't know how to correct
the problem.

Cheers!
 
Top