Subforms

[dr223]

Hi,

Any help!!!! much appreciated......

I have a main form which is build up with a subform. The form and subform are in a relationship with enforce intergrity and cascading deletes enforced.

The delete button when clicked deletes the data in the fields in both the main form and subform. Thats fine!!!

However, I want to have a (del) button whenever a record is added to the subform. This will allow a user to delete a record within the subform without affecting the fields in the main form.

main form: stud_details
subform: pay_det_sub

main form table name: stud_details
subform table name: payr_det

Also, if there is a database as an example with the function used will be appreciated

Thanks

 

[ajetrumpet]

I have a main form which is build up with a subform. The form and subform are in a relationship with enforce intergrity and cascading deletes enforced.

Ref. integrity prevents subform entries before main form entries, that's all. It doesn't affect the deletion of subform entries by themselves.

However, I want to have a (del) button whenever a record is added to the subform. This will allow a user to delete a record within the subform without affecting the fields in the main form.

Then add the button to the form, and delete the appropriate record from the subform using the delete action with the recordset clone.

Make sure to use the appropriate subform reference syntax.