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

Access Open Form Based on condition

P: 1
I was asked if I could open one of two possible data entry forms based on what is chosen in a drop down list. For example, if Teacher A is chosen from a list, then data entry form X opens. However, if Teacher B is chosen from the list, then data entry form Y is opened.

Any thoughts?
Thanks much

Sheldon Soman
[email removed]
May 8 '07 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
You have posted this question in the Articles section. I am moving it to the Access forum.

ADMIN
May 8 '07 #2

NeoPa
Expert Mod 15k+
P: 31,441
I was asked if I could open one of two possible data entry forms based on what is chosen in a drop down list. For example, if Teacher A is chosen from a list, then data entry form X opens. However, if Teacher B is chosen from the list, then data entry form Y is opened.

Any thoughts?
Thanks much

Sheldon Soman
[email removed]
That's perfectly possible.
Put some code to check the value and open whichever form in the AfterUpdate event procedure of the ComboBox.
May 8 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.