Multi-Select Combo Box

[Colorado Spring]

Is there any way to have a Multi-Select Combo Box fill a single field in a table? I've been messing with this for some time now and just can't seem to figure it out.

Thanx in advance
Karen

 

[ejstefl]

I don't understand the question... what would the single field contain, and how would it fill this field if you have multiple items selected in the list box?

 

[Colorado Spring]

Checkbox Versus Multi-Select Combo Box

That's my question. It would fill the text/memo box in the table with the selected values of the list box...perhaps separated by semicolon. I currently have a form with 10 checkboxes, i.e. Technical Issue, Training Issue, etc. In most cases, the user will choose more than one checkbox. Although the checkboxes work okay, it would be much easier to develop reports with just a single field identifying the issue. Perhaps there's no other way than the checkbox but was hoping. lol

Thanx ;<)
Karen

 

[ejstefl]

Well, the problem with doing away with the checkbox, and using one field to store all of the reasons for the issue is that you lose the ability to search for one or a combination of issues.

If you want to have just one field for reports, try adding a field to the recordsouce of your report like so:

Issues: Mid(IIf([Training?]=True,"; Training","") & IIf([Technical?]=True,"; Technical","") & IIf([User?]=True,"; User","") & IIf([System?]=True,"; System",""),3)

Of course, replace the text in brackets [] with your field names, and replace the text in quotes with the name of the issue you want displayed. Add as many IIF statemets as you have fields.

 

[RuralGuy]

Hi Karen,

Here's some demo db's that I got from one of these forums. I don't remember where I got them and I don't know to whom to give the credit but maybe they will give you some hints.