Hi,
I'm using the SQL below as a Row Source for a combobox.
A sample of records from the relavant table is attached.
The first 3 columns are Primary Key.
The value I am attempting to appear only once is 'obj_value = 'Flumegate m" using 0;0;3cm for widths
When I display the row list for the combobox all seems well, but when I select an item in the list the Combobox is not updated.
If I add the first column of the table to the row source, change the column count to 4, alter widths, then it works. However, I don't end up with a nice list of distinct values because the whole row needs to be distinct.
Any ideas?
SELECT DISTINCT tblObject.obt_id, tblObject.oba_id, tblObject.obj_value FROM tblObject WHERE [tblObject.obt_id]=28 AND [tblObject.oba_id]=20;
tblObjectobj_idobt_idoba_idobj_value12819FG_0626_062012820flumegate m128210626_06201282309101282524602228283032819FG_0626_067432820flumegate m328210626_0674328230910328252646342819FG_1050_067442820flumegate m
I'm using the SQL below as a Row Source for a combobox.
A sample of records from the relavant table is attached.
The first 3 columns are Primary Key.
The value I am attempting to appear only once is 'obj_value = 'Flumegate m" using 0;0;3cm for widths
When I display the row list for the combobox all seems well, but when I select an item in the list the Combobox is not updated.
If I add the first column of the table to the row source, change the column count to 4, alter widths, then it works. However, I don't end up with a nice list of distinct values because the whole row needs to be distinct.
Any ideas?
SELECT DISTINCT tblObject.obt_id, tblObject.oba_id, tblObject.obj_value FROM tblObject WHERE [tblObject.obt_id]=28 AND [tblObject.oba_id]=20;
tblObjectobj_idobt_idoba_idobj_value12819FG_0626_062012820flumegate m128210626_06201282309101282524602228283032819FG_0626_067432820flumegate m328210626_0674328230910328252646342819FG_1050_067442820flumegate m
Last edited:
