Form Design: Combo Box Application

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

Guest

i am designing a form that will have seven combo boxes; each combo box will
list various checklist title amounts i.e. functional category checklist combo
box has 16 different checklist titles. then the next checklist combo box is
the general category with 10 checklists titles. from those checklists title
selections i need the contents of the checklist to appear in either a new
combo box, subform or a text box below the combo boxes.

what i am striving for is 1.) from the category combo box, the user will
select a checklist, 2.) the checklist contents will appear in a second combo
box, subform or text box.

that's my goal ... i need assistance with this design on how to accomplish it.

i've struggled for quite some time trying to get this to work ...

the source data comes from two tables; checklisttitles and checklistitems.
i have created queries for the seven combo box categories however, i can't
show the checklist contents in a combo box, subform or text box.

any help with this form design is appreciated.

thanks

doug
 
douglas said:
i am designing a form that will have seven combo boxes; each combo box will
list various checklist title amounts i.e. functional category checklist combo
box has 16 different checklist titles. then the next checklist combo box is
the general category with 10 checklists titles. from those checklists title
selections i need the contents of the checklist to appear in either a new
combo box, subform or a text box below the combo boxes.

what i am striving for is 1.) from the category combo box, the user will
select a checklist, 2.) the checklist contents will appear in a second combo
box, subform or text box.

that's my goal ... i need assistance with this design on how to accomplish it.

i've struggled for quite some time trying to get this to work ...

the source data comes from two tables; checklisttitles and checklistitems.
i have created queries for the seven combo box categories however, i can't
show the checklist contents in a combo box, subform or text box.

any help with this form design is appreciated.

thanks

doug
Click to expand...

Look at these sites:

Rogers Access Library

Scroll down to the C's and look for Cascading combo boxes (several
examples):
http://www.rogersaccesslibrary.com/TableOfContents3.asp

Beginner example:
http://www.rogersaccesslibrary.com/download3.asp?SampleName=CascadingComboBoxes.mdb


The Access Web:

http://www.mvps.org/access/forms/frm0028.htm
 
Back
Top