I have seen before in a database a certain combo box.
I am using MS Access 2000 and Visual Basic.
This combo box had 5 choices, all these choices had a control source to a field called Initiatves; so when a user clicked a choice it was a new record in the initiative field in the tblMain.
The twist is that the user has the option of clicking up to 5 choices. So they can click 1, 2,. or up to 5 etc. And if they choose 5 of the options in the combo box, each 5 choices will be populated as new records in the initiatives field.
It worked like this. The combo box was in a form. Under the label(initiatives) was the combo box, once the user clicked a choice right away a new combo box would appear under the first combo box, with a line in between separating the choices. If the user clicked a second choice with this new box that appeared and wanted a third choice all the user had to do was click under the new line that separates the choices and then another combo drop down box would appear.
I must implement something like this into my database. Can you help me, do you know how it is done?