Opening a form based on user selection in combo boxes

#1 November 13th, 2005, 12:14 PM

I have a main menu that contains 2 drop down boxes.

Drop down 1 contains:
BSL
USL

Drop down 2 contains:
1
2
3
4

Now I have 8 different forms which can be selected next based on the
comboniation selected above. How do I program this to navigate
properly? Any thoughts...

#2 November 13th, 2005, 12:14 PM

use a select case to set up the possible choices is one way....

If cbo1="BSL" then
select case cbo2
case 1
docmd.open form "form1"
case 2
docmd.openform "form2"
...
case else
docmd.openform "form4"
else
select case cbo2
docmd.openform "form5"
etc...
end if

Opening a form based on user selection in combo boxes

re: Opening a form based on user selection in combo boxes

/bytes/development

/bytes/it

/bytes/about