checkboxes not bound to table

[qwertyjjj]

We have a form where we want users to select invoice numbers.
Based on their choice we update a table based on those invoice numbers.

The problem is that to have checkboxes on a continuous form it has to be linked to a bit field in the table. We can't keep adding different bit fields as it is getting messy.

Is there another way to list data on a form and have checkboxes against them, maybe storing the invoice numbers in an array?

Just seems an odd way to bind to the data in a table. I know in VB6 that you never do this, the data is separated between DB and application.

 

[qwertyjjj]

They are columns in a table.
We have a status field but because Access has to bind checkboxes to the data we are having to add a Yes/No field for each of the individual statuses to allow the user to select which ones they want to update.
I don't just see why we can't update the original status integer field but with continuous you cannot separate a checkox to do something individually.

 

[Rabbie]

If you could post an example of your database then we could see exactly what you are doing and possibly be able to advise you on resolving this issue.