combo box values to display checklist

[akika]

hi,

i have a form with a dropdown list of values
e.g category (values, A , B, C).

When select on category, it should display a kind of checklist which will need to tick and save value in table.

each category A, B , C will have their own checklist.
sample db attached.

whats the best way.. to display the checklist and to save the tick data in table??

 

[MajP]

Often done with a multi select listbox. But this will require some code, which you can get here on how to save the selected values to a table.

 

[MajP]

If you want real checks then it would be done with a subform that has a boolean field in it. Will also require code.

 

[theDBguy]

Hi,

Sorry I couldn't download your sample database at the moment but I was thinking one possible approach is to add a Listbox to your form and assign a different Row Source to it depending on what the user selected from the Combobox.

Hope it helps...

 

[June7]

@MajP, did not include link in post. Here is example of iterating listbox http://allenbrowne.com/ser-50.html

The suggestion by DBguy is called cascading or dependent combobox (or listbox) and is a very common topic.