Duane,
The purpose of the main form is to select the Job Code you are looking up the required licenses and certifications needed for that particular position. The sub-form’s purpose is to display the list of required licenses and certifications for the selected Job Code. Do you have a better recommendation to filter and display this data?
Thanks,
Bill
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Tuesday, December 03, 2013 9:49 AM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] Getting Error on Form Close
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
The information contained in this communication, including attachments, is confidential and private and intended only for the use of the addressees. Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you received this communication in error, please inform us of the erroneous delivery by return e-mail message from your computer. Additionally, although all attachments have been scanned at the source for viruses, the recipient should check any attachments for the presence of viruses before opening. Alegent Creighton Health accepts no liability for any damage caused by any virus transmitted by this e-mail. Thank you for your cooperation.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar