Delete all records from a subform

[TG(Denmark)]

I want to delete records in a subform, the recordsource for the form
is:

SELECT * FROM (TEST INNER JOIN SAMPLE ON
TEST.SAMPLE=SAMPLE.ID_NUMERIC) INNER JOIN RESULT ON
TEST.TEST_NUMBER=RESULT.TEST_NUMBER WHERE
(((SAMPLE.JOB_NAME)=forms.frmJobSampleTestResult.Job)) ORDER BY
RESULT.TEST_NUMBER, RESULT.ORDER_NUMBER;

I have tried with this:

DoCmd.RunSQL "DELETE * FROM (TEST INNER JOIN SAMPLE ON
TEST.SAMPLE=SAMPLE.ID_NUMERIC) INNER JOIN RESULT ON
TEST.TEST_NUMBER=RESULT.TEST_NUMBER WHERE
(((SAMPLE.JOB_NAME)=forms.frmJobSampleTestResult.Job));"

but appearently this is not the right syntax, maybe it shoud be
something like:

DELETE * FROM Test WHERE/HAVING???

Can anyone help me?

TG(DK)

 

[Stefan Hoffmann]

hi,

I want to delete records in a subform, the recordsource for the form
is:
DoCmd.RunSQL "DELETE * FROM (TEST INNER JOIN SAMPLE ON
TEST.SAMPLE=SAMPLE.ID_NUMERIC) INNER JOIN RESULT ON
TEST.TEST_NUMBER=RESULT.TEST_NUMBER WHERE
(((SAMPLE.JOB_NAME)=forms.frmJobSampleTestResult.Job));"

but appearently this is not the right syntax, maybe it shoud be
something like:

Copy your record source into a new query, replace your form reference to
the correct syntax. Switch to the designer and use the toolbar to switch
it to a delete statement...


mfG
--> stefan <--

 

[TG(Denmark)]

hi,




Copy your record source into a new query, replace your form reference to
the correct syntax. Switch to the designer and use the toolbar to switch
it to a delete statement...

mfG
--> stefan <--

Thanks, I will go that way
/TG(DK)