I have a combo box named combo159
In this box
SELECT FIREDOORS.[DOOR NO], FIREDOORS.[BETWEEN ROOMS], FIREDOORS.[ROOM/AREA], FIREDOORS.[REQUIRED DETECTION SYSTEM] FROM FIREDOORS ORDER BY FIREDOORS.[DOOR NO];
Is the row source
It gets three values from my table Fire Doors
The Door is in the...