Check box allowing user to choose records to update

[DocNice]

I need to have a query-based form open and allow users to check off (or otherwise indicate) which records they want to update.

I tried having a check box on a continuous form, but when you check one, you check them all. I did a search on this, and saw that if you make the check-box bound, then that will work. But I don't know what to bind it to. I don't want to add another field to an already large and complex table, and I don't know where to put it if not in main table.

 

[KenHigg]

When you move off a record, the table is updated by default - Why would you need a mechanism to do manual updates?

Ken

 

[DocNice]

Okay, I'll be more specific. I need a function that will copy all the records associated with one "filing", assign new ID numbers to them, and make new records out of them. But sometimes they won't need every single record from a filing, and will want to choose which ones not to include.

What I wanted to do was create a form with check boxes that were automatically checked. If they uncheck a box, then that record won't be copied to the new filing.

 

[adevera]

I also encountered this problem on my subform...The way I did is to bind this object to a field.

 

[DocNice]

Yes, but to what field? Do I need to create a new field in my main table? (not desirable)

 

[KenHigg]

I think you're going to have to bite the bullet and add a fld.

You could add another table with routines to do this but it's going to be a lot more trouble...


Ken