Combo Box - Ability to select All

K

Karen

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
 
D

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"));
 
Top