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:

Drop down 2 contains:

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 form "form1"
case 2
docmd.openform "form2"
case else
docmd.openform "form4"
select case cbo2
docmd.openform "form5"
end if

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.