Dropdown Labels

D

Drew

I have a dropdown that is populated by a query. How can I make the first
choice say Select One?

Thanks,
Drew
 
J

Jon Lewis

You can create a union query that adds another row that includes "Select
One" in the relevant column. The number of columns must match and you may
need to add an additional column to ensure that "Select One" appears at the
top of your list.

Here is an example which adds "<Add New>" to the top of a contacts list:

SELECT tblContacts.ContactID, [Prefix] & " " & [FirstName] & " " &
[LastName] AS Expr1,"2" AS IDENTIFIER FROM tblContacts WHERE
(((tblContacts.CompanyID)=[Forms]![frmServiceCall].[txtCompanyID]) AND
(Nz((tblContacts.ContactTypeID))<>7))UNION SELECT 0 ,"<ADD NEW>","1" AS
IDENTIFIER FROM tblContacts
ORDER BY IDENTIFIER, Expr1;

HTH
 
Top