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

[Yousaf Shah]

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 "Cholestero l" from Control "TestName". ...
I want that on selecting multiple items, each item should appear as a separate record. How can this be done?

[NeoPa]

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.

[Mihail]

How you select multiple items from a combo ?
As far as I know this is not possible. Am I wrong ?

[NeoPa]

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.