If only there was an easy way to convert a query grid SQL to a VB query.
The following errors on the line - FORMS!MAINFORM1!SUBFORM1.FORM.AthleteList.Column(0 ))); "
strSQL = "DELETE JUNCTION.ID2, JUNCTION.AthleteID "
strSQL = strSQL & "FROM JUNCTION "
strSQL = strSQL & "WHERE (((JUNCTION.ID2)=[FORMS]![MAINFORM1]![SUBFORM1].[FORM].[ID2]) "
strSQL = strSQL & "AND ((JUNCTION.AthleteID)=FORMS!MAINFORM1!SUBFORM1.FOR M.AthleteList.Column(0))); "
Any suggestions, thanks