CODEWITHSUNDEEP
vbams-access
veryBadProgrammer
veryBadProgrammer

Reputation: 115

How to add Checkbox column in access to query result table

I'm trying to add a Checkbox column to a result table from a query. A form that displays the result table that I need already exists but I need two extra columns in the table. One with a checkbox and another one for text.

So far I've copied the form and the query that gives me the table but I now need to add columns and I can't seem to find a way to do that unless there already is a table that has a checkbox. The one to be used in this Form shouldn't exist outside of the Form though, so I don't want to do that.

Upvotes: 0

Views: 3209

Answers (1)

Pants
Pants

Reputation: 679

Thanks for the screenshots. I think I've got it now.

Adding a checkbox to a Form/Subform(Form within a Form), you can...

Add a checkbox, and not tie it to a record. Leave it unassigned. When the Form displays in "Datasheet View" it will display with each record. Changing its value per row will not affect anything in the underlying database, but can be used for vba code operations for that screen.

If you are adding a checkbox to a QUERY, your hands are tied with one option

Add a checkbox to one of the tables that is used in the query, however this will have to be named something generic to ensure people looking at the underlying data know that this is a bogus box

Upvotes: 1

Related Questions