Link from access forms to Excel file

[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

[Datagopherdan]

My first question would be is why do you have this in Excel at all?