469,919 Members | 2,109 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,919 developers. It's quick & easy.

help require

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.
Oct 30 '06 #1
1 1071
ronverdonk
4,258 Expert 4TB
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:
Oct 30 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by mcp6453 | last post: by
9 posts views Thread by Ryan Miller | last post: by
5 posts views Thread by Eric R. | last post: by
reply views Thread by abcd | last post: by
6 posts views Thread by Steven Kalcevich | last post: by
5 posts views Thread by ibid | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.