Checkboxes updating table

[Ciaran]

I'm just after beginning on a new project, but have a basic requirement that I'm unsure how I can do it.

On a form, I will have a document number. This document can be associated with a number of different states ie one or many. I have set up check boxes so the user can check which state it refers to. My problem is how to take these check boxes in order to populate a many to many table showing document number and states.

eg. If the user selects California, how can I create an entry in the many to many Document Number/State table with doc number and state?

I hope this makes sense and you can help me.

Thanks

Ciaran

 

[jtvcs]

There may be a more elegant way to do what you want, but I would suggest using Append action queries to write the records you need based on which checkbox(s) are checked. HTH JT