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

 

[Pat Hartman]

If the combo is locked, it is most likely because the column count is incorrect. Critical fields in a List or Combobox:
1. Column count MUST = the count of columns in the RowSource query or table.
2. Column widths MUST be blank or have the same number of arguments as there are columns in the RowSource
3. Bound Column MUST point to the unique identifier of the RowSource.

 

[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.

 

[Pat Hartman]

The count refers to the columns selected. If the column does not exist in the recordset, it does not need to be counted.

Sandpiper, try deleting the combo and rebuilding it. There is something wrong with it or its RowSource query.