Hopefully a simple combobox SQL query

[Widge]

Hi there.

I've got a series of comboboxes:

Manufacturer
Category
Sub-Category

What I'm doing is making each box populate based on what is input into
the one above. This I'm fine with.

What happens when you select is that the top line of the combobox is
empty and then the Select Distinct results appear below. What I'm
would like to happen is that the box has a default of <all> in it and
then the select results come below when you click on the drop down.

I've tried setting the box default to <all> but the boxes still have a
blank top line.

Can anyone assist?

 

[Gina Whipp]

This works for me...

SELECT YourFieldName FROM YourTableName UNION Select "ALL" as Bogus FROM
YourTableName;

Then I set the default value for the combo box as "ALL"