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

subform tick box

P: 20
I have a form which contains a subform. This subform is in datasheet format.

The subform contains a yes/no field. This is a tick box.
What i would like to do is just to be able to delete the records which are ticked.

For example if i have 10records in my subform but only 4 are ticked, then i would only like to delete these 4 records.

How would this be possible?
Sep 13 '07 #1
Share this Question
Share on Google+
1 Reply


Scott Price
Expert 100+
P: 1,384
Explore using a DELETE query using the checked value as criteria. Call this del query from a command button on your main form.

First of all create a SELECT query that pulls the records you are seeing on the subform. Then add the criteria in the query design grid where Checked = Yes. Then right click on the query window and choose Query Type, change to Delete query...

Regards,
Scott
Sep 14 '07 #2

Post your reply

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