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

How can multiple selections from a combo become individual records ???

P: 23
Hello every body. I am developing my database for my patients. I have a control "TestName" on my "History" form, with which I select the names of laboratory tests required. When I select Multiple values they are displayed as a single record as "Blood CP;Urine RE;Cholesterol" after selecting "Blood CP", "Urine RE" and "Cholesterol" from Control "TestName"....
I want that on selecting multiple items, each item should appear as a separate record. How can this be done?
Feb 2 '12 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 15k+
P: 31,494
You'll need to start by showing the code you have already developed. We don't do your work for you from scratch.

That said, each item in the list can be added into the table within your loop either by using a SQL command or by using a Recordset.
Feb 2 '12 #2

P: 759
How you select multiple items from a combo ?
As far as I know this is not possible. Am I wrong ?
Feb 3 '12 #3

Expert Mod 15k+
P: 31,494
No Mihail. You're not wrong.

However, it's quite common for people to refer to ListBox controls (incorrectly of course) as ComboBoxes. We'll get to that part once the question is properly presented, if it ever is.
Feb 3 '12 #4

Post your reply

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