OnDelete modification of joined table.

[Ryan]

I've got a form that writes the completion date of the 'batch' we use
into another table to show another group in our office that the first
steps have been done. However, sometimes the batch needs to be
revised and samples removed... but when you delete the rows out of the
datasheet view it doesn't remove the data from the attached table.

Since sometimes they select multiple rows in a datasheet to delete I
want to do something like

for each datasheet.isselected

DoCmd.RunSQL("UPDATE <Table>, SET Completed = [Prepdate], Validated =
GetDate() FROM " & _
"<tableINNER JOIN <table2" & _
"ON <table>.TestNum = <table2>.TestNum " & _
"WHERE (((<table2>.BatchID)='" & Me.BatchID &
"') " & _
"AND ((<table2>.ValidPrep)=1))")

next

However I cannot figure out how to do it for only the selected rows
intended for deletion.

I've fooled around with seltop and selheight, but I cannot get it to
page through the selected results and modify only those rows. can
anyone give me any pointers on this?