Hey guys,
I need help. I have a table "tableI" which has one of its fields ("xyz") which is a multi-select combo-box controlled from another table "tableII" (using inner join with ID field and column bound to 2nd field "ABC".)
Now I have a form which I use to add new records into this tableI. All the fields in form correspond to the respective fields in tableI, however they r not controlled by these fields. they r completely unbounded. After entering information in all fields in the form, when I click on SAVE, all the fields information will get saved into a new record in tableI, for which I have written the code in VBA.
But I face problem adding information to this multi-select combo-box field in tableI.
I see that this combobox field of the table is locked. I mean I cannot simply overwrite it. I see that I can only click on drop-down menu of the box to select/deselect the items. Can anyone help me with this?
Thanks in advance..