Drop Down Selecting No Value

[rmcompute]

Can a drop down be set up to have a no value choice when the table it
references has no such record:

Select Name __________ ^
<No Selection>
Smith, John
Jones, Paul
Smith,Mary

The SQL is Select Name from Name table, but there is no blank record in the
table. Is the only solution to add a blank record to each table and code:

Select IIf(Name is null,'<NoSelection.',Else Name) As Name from nametable ?

 

[Brendan Reynolds]

You can do it with a UNION query ...

SELECT "<No Selection>" FROM SomeTable
UNION SELECT SomeFieldName FROM SomeTable

 

[rmcompute]

It worked. Thank you.

You can do it with a UNION query ...

SELECT "<No Selection>" FROM SomeTable
UNION SELECT SomeFieldName FROM SomeTable

 

[rmcompute]

It worked. Thank you.

You can do it with a UNION query ...

SELECT "<No Selection>" FROM SomeTable
UNION SELECT SomeFieldName FROM SomeTable