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