Cascading List Box in MS Access

dreamer_ire

I'm trying to create a cascading list box on an Access Form. I'm trying to set it up so that the user will choose a "sector" and then that will allow only the organisations in that sector to be chosen.

Any help at all would be appreciate as I've never done this before.

I haven't used Access in a few years, so please feel free to speak in very simple terms!

JonathanAnon

Could you not have a dropdown box listing the "sectors" and have a list box below it which is populated based on what the user selects in the dropdown box? ... tbh, hard to assess without seeing the data..

dreamer_ire

I guess you could, is that easier? Have never done that either. How would I get the list box to populate from the drop down? Forgive me if that's a really stupid question.

Thanks

JonathanAnon

dreamer_ire wrote: »

How would I get the list box to populate from the drop down? Forgive me if that's a really stupid question. Thanks

There will be an OnChange event that will be set off every time the dropdown box changes... Have the listbox requery after the value has changed... The listbox should be dependent on a query that depends on the value of the dropdown box... something like "SELECT * FROM TABLE WHERE SECTOR = dropdownbox.value();" .. that's half code half pseudo code (cos I dont know the field names or input types).. but should give you the idea..

dreamer_ire

Thanks Jonathan, will try that in the morning.