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

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
http://info.yahoo.com/legal/us/yahoo/utos/terms/