Access Database Drop Down Arrows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to setup a drop down list where more than one text selection can be
made.

For instance Field - INJURY TYPE
Drop Down Arrow - Broken right hand

Broken wrist
(I want it so both can be selected)

Is this possible?
 
I want to setup a drop down list where more than one text selection can be
made.

For instance Field - INJURY TYPE
Drop Down Arrow - Broken right hand

Broken wrist
(I want it so both can be selected)

Is this possible?
Click to expand...

Not using a drop-down combo box.
You can using a List box set to MultiSelect.
You'll need to use code to then get each selection.
Access help on ItemsSelected does have an example of how.

However, if you intend to store multiple data in the same record
field, don't. Use a sub table (and sub-form) tied to the PatientID.
Here you can use a Combo Box as you only need select one injury per
record, and you can have as many records as you need.
 
Please clarify what Access help Itemselected is?

fredg said:
Not using a drop-down combo box.
You can using a List box set to MultiSelect.
You'll need to use code to then get each selection.
Access help on ItemsSelected does have an example of how.

However, if you intend to store multiple data in the same record
field, don't. Use a sub table (and sub-form) tied to the PatientID.
Here you can use a Combo Box as you only need select one injury per
record, and you can have as many records as you need.
Click to expand...
 
Back
Top