Prev: Conditional format of a control
Next: Default Value on Form Help
From: aligahk06 on 30 Apr 2010 08:31
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
From: Tom van Stiphout on 30 Apr 2010 09:41
On Fri, 30 Apr 2010 05:31:01 -0700, aligahk06
<abdulhakimkhan(a)hotmail.com> wrote:

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



>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
 | 
Pages: 1
Prev: Conditional format of a control
Next: Default Value on Form Help