how to delete a single record in datasheet subform from main/parent form.

[Jerry Maiapu]

Hi
Please help.

How can I delete i single record in a datsheet subform from main form using a delete button on the parent form.?

i will be more grateful for your help...


jm

[nico5038]

You can use a delete query referring to the current value from the subform.
Check http://www.mvps.org/access/forms/frm0031.htm for the naming convention.
You can use the:

currentdb.execute ("delete * from tblX WHERE ID=" .... )

For the deletion of a specific row in the OnClick event of a button.

Nic;o)