Duane,
As soon as I unbound the main form and the sub-form I started receiving more errors.
Bill
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Tuesday, December 03, 2013 10:06 AM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] Getting Error on Form Close
Bill,
Your use of the combo box and subform are typical.
You didn't answer several of my questions. There were also two recommendation regarding "unbound" that you didn't address in your reply.
Duane Hookom MVP
MS Access
________________________________
> From: william.beshlian@alegent.org
>
> 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
>
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane
> Hookom
>
> 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<mailto: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.
>
>
>
------------------------------------
Yahoo Groups Links
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 (5) |
Tidak ada komentar:
Posting Komentar