Delete Function

[dr223]

Hi,

I have a main form and within it I have a subform. When I click the delete command it deletes the fields on the main form but not on the subform.
This is confirmed by going to the subform table the data is still available. However, on the main form the data is deleted from its respective table.

Main form name: stud_details
subform: pay_det_sub

main form table containing the data: stud_details
subform table containing the data: payer_det

any help will be highly appreciated

Thanks

 

[ted.martin]

You need to look at the MainForm and SubForm relationships, ensuring that Referential Integrity and Cascade properties are checked. Sound complex but it isn't. This is all done in the RELATIONSHIPS window where you link the appropriate tables together and then double-click on the join to set the properties as I have described.

 

[dr223]

Sorry, on the relationship window it shows the tables in a relationship. Where will I be able to see the join so that I can double click it to set the properties. Thanks

 

[ted.martin]

Sounds like you haven't connected the tables and so created the relationships. If you search for 'Relationships' in the Access help section, you should be able to see how to do it.