Many To Many Relationship

[Sandpiper]

Hi
I'm trying to have an area on a form where I can select more than one option from a table. It is a many to many relationship, so i've also got a junction table.
It maybe that i've been working on the same thing for too long and gone brain dead, or that I am a new access user and don't know what i'm doing, but I can't find a way around it at the moment. Can anyone help?
So far, I have created a subform (datasheet) containing a combo box which should allow me to select as many of the options from the drop down as I need, however, the values are being displayed in the drop down list, but it won't let me select them.
Any help gratefully received.
Thanks

 

[Sandpiper]

Thanks for the inforamtion.
I've tried changing the parameters you suggested, but it is still locked. Thanks anyway:

 

[lemon_balm]

Hi Sandpiper

You can't use a combo box for multiple selections. You need to use a list box with the multi-select option set to either simple or extended.

Hope this helps

Regards

Jason

 

[wazz]

1. Column count MUST = the count of columns in the RowSource query or table.

should the 'count of columns in the query' include columns that are not shown, ie criteria-only columns that are not shown, or not? i've never had trouble not counting those but i've often wondered.