I have a combobox in a grid with RowSourceType = 3, and the following RowSource:select partno, descript from PartsList where empty(Prodalias) into cursor TempCombo order by partno
Is there some way to insert a blank row into the beginning of this cursor as part of this statement?SELECT [ -- None -- ] AS partno, [ -- Not Applicable -- ] AS descript FROM PartsList UNION SELECT partno, descript from PartsList where empty(Prodalias) into cursor TempCombo order by partno
You just need to be sure that you use PADR() to make sure that the fields are the same length in both parts of the UNION.
