Bill,
I only expected you to unbind the main form and combo box. I didn't make any statements regarding the subform.
Duane Hookom MVP
MS Access
----------------------------------------
> From: william.beshlian@alegent.org
>
> 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
>
> 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
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar