Selecting multiple choices in a field

[rbenghiat]

I would like to create a Field "Topics" and have a selection of medical
specialities from which to choose "Cardiology, Allergy, Neurology.." But, I
want the user to have the ability to choose more than one topic, so in a
query, I can have it ask the user "which topic" and have the record come up
under all the topics chosen on the form.

can one select multiple lines on a drop down box? should I put my topic
choices in a separate table? I feel like this shouldn't be that hard, but
I'm stuck -

thanks!

 

[mscertified]

Your topic choices definitely should be in a separate table and to allow
choosing more than one, you need a ListBox (not a combo box) with the
Multiselect property set to YES.

Look up this property in Access Help since your next problem will be how to
determine what the user selected.

-Dorian

 

[mscertified]

see other reply