delete a reord 1

[canett]

I tried to build a code for deleting a record in my subform and i get the run time error 3075 missing ,] or item.Could you help me find the error in the folloiwng :

Private Sub cartons_DblClick(Cancel As Integer)
Dim strDelete As String
strDelete = "DELETE [order details].OrderID, [order details].ProductID FROM [order details] " & _
" WHERE ([order details].OrderID = Parent!OrderID AND [order details]!ProductID= Me!ProductID"
DoCmd.RunSQL strDelete
End Sub

 

[TRYP]

i dont see a closing parenthesis in your where clause...

???

 

[TheAceMan1]

and this:

[blue]   Dim strDelete As String
   
   strDelete = "DELETE OrderID " & _
               "FROM [order details] " & _
               "WHERE ([OrderID] = Parent!OrderID AND " & _
                      "[ProductID]= Me!ProductID[purple][b]);[/b][/purple]"
   DoCmd.RunSQL strDelete[/blue]

See Ya! . . . . . .