Bill,
What is the purpose of the main form? Is it bound to a parent table? Is it bound to any table? If the main form isn't for editing or viewing a parent table, it should be unbound (no record source).
If the combo box is used only to select a record for filtering the subform, it should not have a control source (should be unbound),
Duane Hookom MVP
MS Access
----------------------------------------
> From: william.beshlian@alegent.org
>
> Hello,
>
> I created a form with a sub-form that work as advertised. When I go to
> navigate the subform or close the form I receive the following error
> message:
>
> ""The changes you requested to the table were not successful because the
> would create duplicate values in the index, primary key or relationship.
> Change the data in the field or fields that contain duplicate data,
> remove the index or redefine the index to permit duplicate entries and
> try again."
>
> What would cause this error while attempting to navigate the sub-form or
> on close? All I need to do is have the sub-form display what is realted
> to what I selected in the combo box in the main form which it does.
> Then close it when I am done. Thanks in advance.
>
> Bill
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar