I am trying to create a form using VBA which will be a list of people, in a particular group, with a checkbox next to each name. The point of the form is so that the user can check those individuals who shoud not be included in a particular process. The names are the result of a query and the list will be of different lengths each time. I have tried to create a query with the first field being the person's name and the second field a checkbox, which would default to No. Then I would be able to use each name with it's checkbox to accomplish this. What I really need help with is the query, so that one of the output fields is a checkbox.
Create query with checkbox in result
- Thread starter ttutela
- Start date
neileg
AWF VIP
- Local time
- Today, 00:52
- Joined
- Dec 4, 2002
- Messages
- 5,970
You can't store data in a query, so there's nowhere for the checkbox data to go. You will have to have a table to store this.
I suspect the most appropriate way to to this will be to create a new table that holds a field for the primary key field linked to the person name and your checkbox (default set to No). Link this in to your underlying query. When you check the checkbox, this will create a record in the new table. After you have used this checkbox data, delete the records in the new table so that the next user is presented with an empty table.
I suspect the most appropriate way to to this will be to create a new table that holds a field for the primary key field linked to the person name and your checkbox (default set to No). Link this in to your underlying query. When you check the checkbox, this will create a record in the new table. After you have used this checkbox data, delete the records in the new table so that the next user is presented with an empty table.
Similar threads
