Hopefully a simple combobox SQL query

  • Thread starter Thread starter Widge
  • Start date Start date
W

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?
 
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"
 
Back
Top