Combo Box - Ability to select All

[Guest]

Is there a way to have a combo box include a selection in the drop down that
will display "all". I use the combo box selection to populate the criteria
of a query. Below is the sql for the query:

SELECT tblClientDetail.ClntDetID, tblClient.GroupName, tblClientDetail.Fund
FROM tblClient INNER JOIN tblClientDetail ON tblClient.ClientID =
tblClientDetail.ClientID
WHERE (((tblClientDetail.Product)=[Forms]![frmSelectClient]![Product]));

Thanks

 

[Douglas J. Steele]

SELECT tblClientDetail.ClntDetID, tblClient.GroupName, tblClientDetail.Fund
FROM tblClient INNER JOIN tblClientDetail ON tblClient.ClientID =
tblClientDetail.ClientID
WHERE (((tblClientDetail.Product)=[Forms]![frmSelectClient]![Product]))
OR (([Forms]![frmSelectClient]![Product] = "All"));

 

[Guest]

Check this link on "Adding "All" to a listbox or combobox"

http://www.mvps.org/access/forms/frm0043.htm