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

Select Multiple Email address from Listbox or Combo box in MS Access

P: 1
I have a Project in MS Access in which i have made a 4 Table. The table name is as follow Planning, Quality,Production and Manufacturing, each table contain email address.
Now in Form i have made a Combo box which show the name of the Table(Planning, Quality,Production and Manufacturing).So now i want a another Combo box or any other box which show the Email address of particular sector. For example when i select the Planning in 1st combo box, the second box should show me all the email address of planning sector. And i can select one or more email address from that second box.

Can anyone has Idea how to do this? as i am new and dont have much knowledge of MS Access.
Thanks in Advance.
Oct 25 '18 #1
Share this Question
Share on Google+
1 Reply


twinnyfo
Expert Mod 2.5K+
P: 3,055
jugalsonar007,

Welcome to Bytes!

You say you don't have much knowledge in MS Access, so we may have to walk through this one slowly.

You can easily do what you want to do in VBA.

In the After Update event of the first Combo Box, you would use the value of that Combo Box to generate a list of e-mail addresses from the selected table, and then assign that list to the Recotrd Source of either a second Combo Box or a List Box.

That is the concept.

Depending on how much or how little you understand about VBA programming will determine how much greater detail I provide as this thread goes on.

Standing by to assist further.

Hope this hepps!
Oct 25 '18 #2

Post your reply

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