Hi All.
Creates query with default value to populate the ComboBox:
Now when form is ran the ComboBox display a blank field. I would like when I ran a form default value "Select Type" will be display in the ComboBox. How to do that?
Thanks.
Creates query with default value to populate the ComboBox:
Code:
SELECT DISTINCT DeviceType.DeviceTypeID, DeviceType.DeviceType,1 AS SortRow
FROM (Device LEFT JOIN DeviceType ON Device.DeviceTypeID = DeviceType.DeviceTypeID) LEFT JOIN Brand ON Device.BrandID = Brand.BrandID
WHERE (((Brand.BrandID)=[Forms]![f_Device]![cboBrand]));
UNION SELECT 0, "Select Type", 0 FROM DeviceType
ORDER BY SortRow, DeviceType.DeviceType;
Now when form is ran the ComboBox display a blank field. I would like when I ran a form default value "Select Type" will be display in the ComboBox. How to do that?
Thanks.