B
Boon
Hi,
I have an error when using a subform.
I have a combo box in the main form. When the user choose the value in the
combo box, the subform will populate the data that linked to that value.
(says. the combo box is invoice ID. Then after choosing the ID, the subform
will display all the items that have the same invoice ID.
Now when I click in the cells in the subform, Access pop up the message read
"The record cannot be deleted or changed because table 'Sales' includes
related records. (table 'Sales' is where I hold invoice-item list.
Why Access shows this error? I want to be able to change or delete in the
subform. How can I solve this problem?
Thank you,
Boon
I have an error when using a subform.
I have a combo box in the main form. When the user choose the value in the
combo box, the subform will populate the data that linked to that value.
(says. the combo box is invoice ID. Then after choosing the ID, the subform
will display all the items that have the same invoice ID.
Now when I click in the cells in the subform, Access pop up the message read
"The record cannot be deleted or changed because table 'Sales' includes
related records. (table 'Sales' is where I hold invoice-item list.
Why Access shows this error? I want to be able to change or delete in the
subform. How can I solve this problem?
Thank you,
Boon