I've just spent the past few hours trawling through the website looking at various solutions for this problem, but none of them seem to work for me.
I have 3 cascading combobox's which control what is displayed by a query on a listbox. The query criteria is direcltly linked to each combobox. (done by typing in [Forms]![frmEngineDirector
Type] in the criteria space in Query Design View)
I have been trying for the past couple of days to integrate an <ALL> option into all 3 combobox's but have failed miserably.
The 1st combobox looks up the main table (tblEngineDetail) for a "Text Data Type" and the 2nd and 3rd refer to the main table for a "Number Data Type"
I can add the <ALL> header to the 1st combobox but not to the 2nd & 3rd since they are "Number Data Types". I keep getting the error "The value you entered isn't valid for this field". And even though I can add <ALL> to the 1st Combobox, I dont know how to parse on "*" to the query so it can display all data related to the 1st combobox.
Currently for the 1st combobox, Im using the rowsource code shown below. I dont understand how some solutions add a second variable to the combobox so that they can have <ALL> and "*" in the combobox; but then my query criteria reference would not work anymore.
Im open to any suggestions. thanks alot everyone in advance.
SELECT DISTINCT tblEngineDetail.charEngineType FROM tblEngineDetail UNION Select '<ALL>' From tblEngineDetail;