The changes you requested to the table werenot successful ........

[aligahk06]

Dear All,

I wont be able to feed data to my form named (DelNoteBrkForm) which is
created from Delivery_Track Query.
The thing is that if i m saving my records to the form (DelNoteBrkForm)
record could not be saved.
The eroor encountered was
The changes you requested to the table werenot successful because they would
create duplicate values in the index,primary key,or
relationship.Change tha data in the field or field that contain duplicate
data, remove the index or redifine the index to permit
duplicate entries and try again.

Actually i want to open this form with all records from the form
Delivery_Track ( There is a command button )
OPenSubForm.
Suppose i am searching Delivery No 22568 and once i click on command button
opensubform then it will directly redirects us to the
DelNotebrkform and show us the corresponding Delivery No and their fields.

Attachment is for ur reference.

Please assist ?

Rgds,
Aligahk06

 

[Tom van Stiphout]

On Fri, 30 Apr 2010 05:31:01 -0700, aligahk06

There are no attachments in a text-only forum.

You can't "save records to the form"; rather you save data to the
table(s) that the form is bound to.

The error message indicates that you're trying to save a record that
is similar to one that already exists. For example if I have a unique
index on OrderID + ProductID in my OrderDetails table, and I try
saving a second line item for this order with the same Product, this
error will occur. Review your database design and the reason for the
error should become apparent.

-Tom.
Microsoft Access MVP