How can I design my form to select multiple values from a combo box? For example, I have a trouble database and have an 'issue type' combo box where I can only select one value. I would like to select multiple values separating them with like a comma or semi-colon.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Selecting multiple values from a combo box
- Thread starter RGarcia87
- Start date
Are you expecting to bind these values to a field in a table? If so, this is considered by most experienced developers to be a bad practice.
If you want to allow storing multiple "issue types" for each "trouble" record then you should create a related table that has one record for each trouble/issue type pair.
If you are using the multi-select to filter a form or report, you may need to change the control from a combo box to a list box which can be set to multi-select.
Another option is to use Access 2007 which implements multi-valued fields.
Duane
Hook'D on Access
MS Access MVP
If you want to allow storing multiple "issue types" for each "trouble" record then you should create a related table that has one record for each trouble/issue type pair.
If you are using the multi-select to filter a form or report, you may need to change the control from a combo box to a list box which can be set to multi-select.
Another option is to use Access 2007 which implements multi-valued fields.
Duane
Hook'D on Access
MS Access MVP
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question