listbox - Displaying a multivalued list box/combo box in Access 2010 -


i have table containing information teachers university. 1 of fields multivalued list box containing choices types of students person teaches (pre doctoral/post doctoral/residents etc). trying display field on form, letting form wizard create controls form ends giving copies of same record each copy showing different selection students field (i.e. if select pre , post doctoral, record selector shows 2 records, both exact same information except 1 of student fields says pre doctoral , other says post doctoral).

i want show each option in list on 1 record. can't seem find kind of property can this. want able show possible options when adding new record. there options/code allow this?

my answer, may not like, not use multi-value listbox (or attachments field either). create hidden tables , relations cannot control and, want useful them, becomes problematic. cause issues exporting well.

i create, , maintain, own tables (a many-to-many relationship).


Comments

Popular posts from this blog

curl - PHP fsockopen help required -

HTTP/1.0 407 Proxy Authentication Required PHP -

c# - Resource not found error -