Wanting to add a checkbox to the detail area of a continous form

[fathi_abuayyash via AccessMonster.com]

I've built a continous form based on query to show all the records. I now
want to
add a check box beside each record, so that I can check specific
records.

I tried to add the checkbox to the underlying query, but I
can't check it in the form because the query is not updatable and
therefore won't let you change data in the bound query fields.

the query based on linked table, therefore, i can not add yes/no field..
is there work around?

Thanks

 

[George Nicholson]

Adding a Yes/No field (or any field) to a query would automatically make it
un-updateable: Access has no place to store the information for that field,
so the whole query becomes unupdateable. Its a basic all-or-nothing
situation.

If you want to toggle a Checkbox, it has to be in a table.
1) add it to the backend table (wherever the table you are linking to
resides).
2) run a make table query (including the check box) that creates a local
table that you could then query and modify *if* the only thing you want to
modify is the additional Yes/No field.

 

[fathi_abuayyash via AccessMonster.com]

Thanks!

Adding a Yes/No field (or any field) to a query would automatically make it
un-updateable: Access has no place to store the information for that field,
so the whole query becomes unupdateable. Its a basic all-or-nothing
situation.

If you want to toggle a Checkbox, it has to be in a table.
1) add it to the backend table (wherever the table you are linking to
resides).
2) run a make table query (including the check box) that creates a local
table that you could then query and modify *if* the only thing you want to
modify is the additional Yes/No field.

I've built a continous form based on query to show all the records. I now
want to

[quoted text clipped - 9 lines]

Thanks