ListBox Checkbox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DS - 28 Nov 2005 15:35 GMT

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

Reply to this Message

Warrio - 28 Nov 2005 18:25 GMT

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

>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
[quoted text clipped - 5 lines]
> Thanks
> DS

Reply to this Message