Delete from subform (simple)

[gfcaim]

I have a subform that i have added a button that runs a delete query. The query selects the record to delete based on the subform record ID. If i open the subform on its own it works fine, but from the parent form it acts as a parameter query, asking for the ID. So it's obviously an addressing error.

Can someone please put me right - the query (incorrcetly) uses:
[Forms]![frm_SUB_Training]![ID]

 

[adam_fleck]

Something like this:

[Forms]![frm_Training]![Name_of_SF_Control].[Form]![ID]

This should work if you replace Name_of_SF_Control with the name of control on your training form that your subForm is showing up in. By default this will be something like Child8.

 

[gfcaim]

thanks

thanks - quite right, it does work.