I have a form which contains a combo box bound to a multi-select column in a table. The bound column is the PK (Autonumber) with a column count = 2 and column widths of 0cm; 2.544cm, which displays and stores the data as I need.
The issue I have is that after a user makes a selection from that combo-box and then either clicks OK or Cancel the values displayed in the form field at the PK values and not the associated text. Once the focus moves from that cell the values displayed are corrected (i.e. text opposed to PK autonumber).
I cannot find an event associated with the OK/Cancel buttons on the multi-select combobox list to hook some VBA to to allow me to Lose Focus/Set Focus so reformatting the displayed values.
Has anyone ever come across this before and been able to resolve it?
I am using Access 2007/2010
The issue I have is that after a user makes a selection from that combo-box and then either clicks OK or Cancel the values displayed in the form field at the PK values and not the associated text. Once the focus moves from that cell the values displayed are corrected (i.e. text opposed to PK autonumber).
I cannot find an event associated with the OK/Cancel buttons on the multi-select combobox list to hook some VBA to to allow me to Lose Focus/Set Focus so reformatting the displayed values.
Has anyone ever come across this before and been able to resolve it?
I am using Access 2007/2010