SQL Query to compose a Combo Box List

[Karen]

I use the following to create a 'list' for a combo-box on a form

SELECT Agency.AgencyID, Agency.Name, Agency.AgencyType, Agency.Abbreviation
FROM Agency WHERE (((Agency.AgencyType)="Adjusting")) UNION SELECT
0,"(New)", "Adjusting", "(New)" FROM Agency
ORDER BY Agency.Name;

It pulls info from the Agency table AND adds '(New)' as a choice. If
'(New)' is selected then another form opens to caption the data for a 'new'
Agency.

When I clear the tables in the back-end database, then compact to start with
a fresh database, the 'list' for the combobox is completely blank whereas
what I want to see it '(New)' only since it is a 'clean' database.

It does not, the 'list' is completely empty. What am I doing wrong?

 

[Karen]

Hi All,

With no response to this post, does that mean that it appears OK, the query
should include the '(New)' choice in the combobox list?

--
Karen
I use the following to create a 'list' for a combo-box on a form

SELECT Agency.AgencyID, Agency.Name, Agency.AgencyType, Agency.Abbreviation
FROM Agency WHERE (((Agency.AgencyType)="Adjusting")) UNION SELECT
0,"(New)", "Adjusting", "(New)" FROM Agency
ORDER BY Agency.Name;

It pulls info from the Agency table AND adds '(New)' as a choice. If
'(New)' is selected then another form opens to caption the data for a 'new'
Agency.

When I clear the tables in the back-end database, then compact to start with
a fresh database, the 'list' for the combobox is completely blank whereas
what I want to see it '(New)' only since it is a 'clean' database.

It does not, the 'list' is completely empty. What am I doing wrong?