Listbox selection. to another listbox of that selection...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you set-up a Listbox to make a selection, and then show another
Listbox that allows follow-up selections of the original choice? For
example: If I choose "Colors" as the original selection, I would like to
choose from the "Red", "White", and "Green" colors from another listbox.

I'm using Access 2000.

Thank you!
 
Ken, thanks for the reference. I tried several times but wasn't able to get
it to work, as I was confused as to where he wanted the names of the
listboxes, forms, fields go.

I need your help, please...

I have 9 DRM records in a table called tblDRMs. 1st field= DrmID, 2nd
field=DrmName
I have 19 School records in table called tblSchools. 1st field= SchoolID,
2nd field=SchoolName

I created a form for the DRM Listbox called frmDRMSelectionsMenu.
I created a form for the School Listbox called frmSchoolSelectionsMenu.

My 1st Listbox is called DRMsListBox. 1st field= DrmName, 2nd field=
DRMDescription. I put the DRMsListBox on the frmDRMSelectionsMenu.

My 2nd Listbox is called SchoolsListBox. 1st field=SchoolName, 2nd
field=SchoolDescription. I put the SchoolsListBox on the
frmSchoolsSelectionsMenu.

So, I would like to either put both listboxes on the same form or have them
come up separately, selecting a DRM first and then selecting a school in that
DRM afterwards- that will eventually open a file called frmAssessorPage for
that selected DRM and School.

What codes do I need to write this and where do I put them?

Regards,

Heidelberg
 
Cascading listboxes, which is what you seek to use, typically would be used
on a single form, not on separate forms. So I think the better design for
your setup will be to put both listboxes on the same form.

Can you tell us what you tried for the code setup and what didn't work? That
way we can show you how to adapt the code to your idea.
 
Ken, in looking at my messages I found that I didn't answer your last
response. Sorry!

I took your idea and did a search on cascading listboxes and was able to get
it to work.

Thanks for steering me in the right direction!
 
Back
Top