Subform error

G

Guest

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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Editing data on subform 4
records in subform 2
records in subform 6
conditionally visible subforms? 4
update form after adding to combo box 20
Access Main form/Subform Navigation 0
Access Reference Subform's Control 0
Assistance with Subform Synching 9

Top