combo box values to display checklist (1 Viewer)

akika · Nov 1, 2018

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 · Nov 1, 2018

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 · Nov 1, 2018

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 · Nov 1, 2018

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 · Nov 1, 2018

@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.

combo box values to display checklist (1 Viewer)

akika

Registered User.

Attachments

MajP

You've got your good things, and you've got mine.

MajP

You've got your good things, and you've got mine.

theDBguy

I’m here to help

June7

AWF VIP

Similar threads

Users who are viewing this thread