Checkboxes on Forms

[blahblah]

I am very new to Access, so bear with me please.

How do you create a form that will query a list from a table, and then separate each invidivual entry from the query into its own checkbox?

Example:

*run query or something similar, and 3 items are brought up*

Tracking Form 00001:

Item1 [x]
Item2 [x]
Item3 [x]

Each individual item in the query might change, so I want to keep it flexible. Once all of the checkbox options are organized and put onto that section of the form, I want to append all of the values that were checked off into a field on another table. So for example let's say the person inputting the form checked off item1 and item3, the field on the table linked to it would now have field1="item1, item3".

Is there a way to do this without a lot of coding, possibly just using the menu-driven interfaces and maybe a coded query? I am not that familiar with Access so any help is appreciated.

 

[blahblah]

Variation on the above post:

I want to make part of my form something like this:


Did anything get added? [] Yes [] No

(if they click on the Yes checkbox, the list below appears):

Enter the items that got added:
[] Item1
[] Item2
[] Item3


Is this something very complex to do, or no? I'm guessing it's a checkbox into a subform, but when I try to added a subform from the checkbox option it gives me the error about it being an incompatible data type...

 

[Banana]

Why can't you use a multi-select listbox? There's several good examples of using them if you search the forums.