Unanswered: ComboBox Listcount returns incorrect value?
I've got a bunch of comboboxes scattered throughout this db I'm developing, they all are populated using an SQL statement and the .RowSource property within VBA. A great many of them are checked using:
and they all work flawlessly....until I built one this morning. I've got one combobox that insists its .listcount = 1 when it returns a empty list (ran the SQL thru Query Builder to verify). I don't have column headers turned on, just my standard combobox properties...nothing which should create its own index.
if cbo_Blah.ListCount = 0 then
do some code
The SQL statement behind the box is this:
Any ideas why this would return a listcount property of 1 instead of 0 like it should? The Model_Number table isn't populated with test data yet, so no manufacturer has any child model numbers at this point.
cbo_Manuf.RowSource = "SELECT DISTINCT tbl_Item_Manufacturer.Manufacturer_ID, " _
& "tbl_Item_Manufacturer.Manufacturer_Name" _
& "FROM tbl_Item_Manufacturer INNER JOIN tbl_Item_Manufacturer_Model ON " _
& "tbl_Item_Manufacturer.Manufacturer_ID = tbl_Item_Manufacturer_Model" _
& ".Manufacturer_ID ORDER BY tbl_Item_Manufacturer.Manufacturer_Name;"
Sam, Bah! I hate Mondays.
Good, fast, cheap...Pick 2.