Please could someone tell me if it is possible to access the value of the bound column of a combobox in a table where its columnwidth is set to 0. I need to be able to display NAME in table view for the user but I need to be able to get the ID value from a regular query.
I have 2 tables The first is tblClient the second is tblHK. I have added a field to tblClient called ‘AssignedHK’ and used the lookup tab in table design view to set ‘Display Control’ to Combo Box. The row source is “SELECT tblHK.ID, tblHK.Name FROM tblHK”;
The comboBox field works fine I can click on the AssignedHK and see HKname.
My problem is then designing a query that lists the ID values. I can’t see how to address the bound column value (ID).
Any help appreciated even if only to say can’t be done.
I have 2 tables The first is tblClient the second is tblHK. I have added a field to tblClient called ‘AssignedHK’ and used the lookup tab in table design view to set ‘Display Control’ to Combo Box. The row source is “SELECT tblHK.ID, tblHK.Name FROM tblHK”;
The comboBox field works fine I can click on the AssignedHK and see HKname.
My problem is then designing a query that lists the ID values. I can’t see how to address the bound column value (ID).
Any help appreciated even if only to say can’t be done.