help require

[skumars118]

I would like to add a check box to the detail area of a continous
form. So that I can check on specific records, then after I've marked
all the records I watn to delte, click a button to loop thru these
check boxes, if checked get the field with the underlying table record
ID and run a query to delete it.

I've built a continous form to show all the records. I now want to
add a check box beside each record, so that I can check specific
records. Then I'll place a button on the header area to run a
function to detlete those records that are checked from the undelying
tables. I tried to add the checkbox to the underlying query, but I
can't check it in the form because the query is not updatable and
therefore won't let you change data in the bound query fields.

[ronverdonk]

Who is the boss here? You are in your own program! So when you display the rows you can prefix them with a button. When the form is submitted (via the box at the top), you could certainly verify the checkboxes and delete the related db records.

What I don't quite understand is the part

I tried to add the checkbox to the underlying query, but I
can't check it in the form because the query is not updatable and
therefore won't let you change data in the bound query fields.

.
What do you mean by add the checkbox to the underlying query? Let's assume you have displayed the row in a table cell. Then you could prefix that row <td> with another <td> with the checkbox and the key of the row in it. Why should you want to update the query for that?

Ronald :cool: