combo box or check boxes?

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

Guest

I would like to know when entering data into an Access table can I have a
Combo Box , or something, where the values are given but you can choose more
then one value in the list, like check boxes? The data I am enterering are
survey answers so for one question the respondent could choose several of the
choices given.

I appreciate any help you can give me!
 
I would like to know when entering data into an Access table can I have a
Combo Box , or something, where the values are given but you can choose more
then one value in the list, like check boxes? The data I am enterering are
survey answers so for one question the respondent could choose several of the
choices given.

I appreciate any help you can give me!
Click to expand...

Gail, I don't know if you're getting bitten by the Microsoft website
bug which falsely says that your message didn't post, but it did...
seven times in fifteen minutes. If you're impatiently waiting for an
answer, be aware that this newsgroup is staffed by unpaid volunteers
like me, who check for messages on a time-available basis. It's not a
chat room. If you *did* get the error message - ignore it henceforth!

A Listbox with its Multiselect property set will do this, with some
VBA code... but you need to have your tables properly structured. You
CANNOT store multiple values in one field; you need at least two
tables.

For an excellent, well worked-out survey database see Duane Hookum's
AtYourSurvey sample database:

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top