Forms

[Suzy]

I am new to Access and trying to create a form . One element has a combi box and I want the user to be able to choose more than one selection from the list in my combi-box. Is that possible at all? At the moment, I can chose only one line from my combi-box. Thanks

 

[Mile-O]

No, it's not possible with a combobox.

A listbox has a Multi-Select option which you can set to either Simple or Extended to allow multiple selections.

 

[Suzy]

Thanks but when I changed to List Box, all the options started appearing on the form, the scroll bar vanished. Please help me.

 

[Mile-O]

Yes, listboxes are different from comboboxes in that they show a list rather than allow a drop down like a combo.

Can I ask what exactly it is that you want to do and I'll see if I can suggest a better way?

 

[Suzy]

I am creating a database for my teachers where they can keep records of students' assignments and marks etc.i am trying to make a list of comments, from which the user can choose any number they want. Can you please suggest a better way?

 

[Mile-O]

A form and subform combination.

 

[Suzy]

thanks again, would u kindly tell me how to do that? I tried working on the file u had sent but couldn't see how it worked.

 

[Mile-O]

It involves simulating a many-to-many relationship by creating three tables.

One for students, one for comments, and a "junction" table that serves to connect them as one student can have many comments and one comment can apply to many students.

The main form is connected to the students table while the subform is linked to a query that links the three tables.

The subform has a property called Link Child Fields. You link the primary key - in this case StudentID - between the two forms. Any selections made go into the junction table.

Actually, I find this rather hard to explain....

 

[Suzy]

thank you very much for your help. I am trying all over again.

 

[Mile-O]

Just so you know, with the drop downs on the subform the field with the StudentID was hidden. I saw no reason to show it.