Relating unbound tickboxes to record on continuous form

[Dan2kx]

New question....

I have my continous form constructed of data from a query, i want to select records to edit (See thread) using unbound tickboxes, how can i link these?

Thanks (again),

Dan

[ChipR]

How do you have your unbound checkboxes set up? I had assumed your check box was bound to a field in the table because, as far as I know, they can't be used in continous forms without some very complex code.

[Dan2kx]

Yeah previously i used the continuous form with a checkbox that was bound,

i just realised that in this situation (building now) that it isnt bound, anyway to spoof a checkbox in the select query that the form is based upon!?

Dan

[ChipR]

I'm pretty sure that wouldn't be editable. You may have to add a field for it.

[Dan2kx]

hmmmm,

mayb i could use an make table query to make a new table WITH a checkbox and delete it when done!?


Dan

[Dan2kx]

Or go back to listboxes LOL

[ChipR]

Have you considered a listbox? I have a form with 2 listboxes, one with unselected items, and one with selected. Arrow buttons in between to move things back and forth. Once the items are added to the listbox, it's easy to loop through them and create the string.

[ChipR]

Hah, great minds and us think alike.

[Dan2kx]

yeah i may have to (listbox), i am trying to make my forms as dynamic as possible, not sure why, i just like it....

Looks like i will need two of these forms

Edit: ^^Great minds indeed!!