Wanting to add a checkbox to the detail area of a continous form

[adolph]

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.

I've also tried to add a check box to the detail portion of the form,
but when in use, if you click on one box, they all change.

For now I've added a button in the detail portion of the form. When
clicked, the sub gets the RecordID from one of the fields then runs a
delete query then refeshes the form. Its very slow.

Adolph

[DFS]

You'll probably want to add a Yes/No field to the underlying table.
"adolph" <ad****@markethost.com> wrote in message
news:71*************************@posting.google.co m...

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.

I've also tried to add a check box to the detail portion of the form,
but when in use, if you click on one box, they all change.

For now I've added a button in the detail portion of the form. When
clicked, the sub gets the RecordID from one of the fields then runs a
delete query then refeshes the form. Its very slow.

Adolph