ListBox Checkbox

D

DS

I have a listbox, when you click on it, it filters the contents in
another listbox. This works fine. my question is, instead of having
the second listbox I want a series of 7 checkboxes, one for each day of
the week. I want to be able to display whether that checkbox is checked
for that particlar record and if it;s not have the option to check it.
Right now the second listbox displays the days but I need to do it from
a checkbox....any suggestions?
Thanks
DS
 
W

Warrio

One suggestion is to create 7 records (into a table) for each record of your
left listbox
and then display (when the user selects a line in the listbox) the 7
records, that are related to the line selected, in a continious subform

for instance:

LeftListBox:
ID | Name
=========
1 | Jhon
2 | Maria
5 | Jean

Continuous SubForm
ID | Day | Checked
===================
2 | Mon. | Yes
2 | Tue | Yes
2 | Wed | Yes
2 | Thu | No
2 | Fri | Yes
2 | Sat | No
2 | Sun | No
 
Top