Can I add a checkbox to a query that is not bound to table?

[wackywoo105]

I have some VBA code that generates a query and saves it. The query is a list of people who will be sent a communication along with the formatting for the communication. After producing the query I want to look through it and decide if there is anyone I don’t want to send the communication to. I can’t delete records from the query without deleting them from the database or I would simply do this.

I thought I could add a checkbox in the query that I can tick to stop a communication being sent to that person. I only want the setting saved within the query and then when I have finished it be deleted along with the query.

Is this possible?

 

[spikepl]

Not really.

You either need to make a colum in a table (or two, if there are more than one user, so that you can record each user's decisions independently) OR you can work with a detached ADO recordset - but that is not for the faint-hearted.

 

[pbaldy]

It would have to be bound to work. I might base a multiselect listbox on the query and use that to choose.

 

[vbaInet]

You can get checkboxes with a listview control but it's easier with pbaldy's multi-select listbox.

 

[wackywoo105]

Cheers all. I thought as much but wondered if there was a way round it. I will just add a field to the table and included it in the query.

 

[vbaInet]

I will just add a field to the table and included it in the query.

You really don't need to do that. Just use a multi-select listbox like pbaldy suggested. This is how it's done in a multi-user environment.