By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,681 Members | 1,864 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,681 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.