By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,635 Members | 2,240 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,635 IT Pros & Developers. It's quick & easy.

Opening a form based on user selection in combo boxes

P: n/a
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...

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.