Subform record deletion from main form

[cath_hopes]

How do I delete a subform record from the main form using vba?

Thanks in advance!
Catherine

 

[ajetrumpet]

Probably like this:

docmd.runsql "DELETE * FROM [TheSubform'sTable] " & _
   "WHERE [CriteriaField] = [YourCriteria]"

me.SubFormControlName.Requery