Unbound checkbox on continous form.. Delete ones that are checked

[cdoyle]

Hi,

I have a continuous form, and using the method I found here. To allow for unbound checkboxes on the form.

I was able to get the checkboxes to work OK, I can now put a check on all the rows that I want to select.

What I want to do next though, is have a button that deletes all the records that are selected. I'm not really sure how to go about it.

I've attached my sample db, the form in question is named duplicate_work_weeks_f

anyone know how to go about deleting just the ones selected on the form?

Thanks,

 

[highandwild]

Hi

I do this often and have a field called [tag] in the table which the
checkbox on the form is bound to. I can then run a delete query that delete all records where [tag] = -1. You can call the field what you like.

There must be other ways but this works for me.

 

[cdoyle]

Hi

I do this often and have a field called [tag] in the table which the
checkbox on the form is bound to. I can then run a delete query that delete all records where [tag] = -1. You can call the field what you like.

There must be other ways but this works for me.

Ya I was thinking of just doing that, but then saw this method of having a unbound checkbox, and was hoping to make it work using that. I have it so I can select them, but not sure how to actually delete them.

I might just go with the extra column in the table method.

 

[highandwild]

Can you post a link to this method as I can see it having applications but not for this problem.

I wonder what others will come up with.

 

[cdoyle]

Link

go down to where it says Multi Select Example.

 

[highandwild]

What a coincidence.

I was just looking at that database yesterday and the developer gave me
lots of help from his site.

This method builds up a string which is used in the WHERE clause of the delete query.If you want to do it this way make sure you understand how it works first.

I often want to build up a list of records to be deleted in various ways and from various forms before carrying out the deletions. Having a field allows that to be possible. I often create an audit of deleted records so that one can see who deleted them, when and possibly why.