Subform error

J

Jenny

Err msg: Err Msg: The changes you requested to the table were not successful
because they would create duplicate values in the index, primary key or
relationship.

I have researched this on the web and there seems to be a bug in Access 2003
with this error msg but I am using Access 2002.

I have a main form with a combo box to choose client.

A subform displays all events relating to the chosen client.

For ONE of those clients, I am allowed to edit data in the subform. For the
rest I get the above error msg.

I have checked the indexes, relationships and Pkey's and they are all in
line with the Access rules.

The only thing that seperates the ONE client's events I can edit in the
subform form the others, is that is the first in the list. Otherwise it has
things in common with all the other clients


Please can you help? Is there any known bug here & if so please how do I
fix it?

Thanks a lot

Jenny
 
J

Jenny

SORRY PLEASE IGNORE THIS POST AS IT IS IDENTICAL TO POST BELOW! Would really
appreciate help on below though!
Thanks
 
Top