How to get the first row in combobox blank 3

[Katya85S]

Hi guys.
How do I get the first row in combobox blank. It's row source is a Select statement of a table:
Select ID, Field1 from tblTable order by Field1.

The combo box displays the Field1 value, starting from an 'A', but i need it to be a blank unless user specifies otherwise.

thank you all in advance.

 

[Remou]

A bound combo will only be blank if the field it is bound to is blank or null.

 

[randy700]

Use a UNION query to create the blank row. Something like...

SELECT EmpID, LastName FROM tblEmployees UNION SELECT 0, NULL FROM tblEmployees ORDER BY EmpID

Randy

 

[Katya85S]

Thanks much guys!!!

 

[PWise]

put in the default value that is not in the table

 

[Katya85S]

Great!
many thanks pwise!