Combo Box - Ability to select All

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Karen - 31 May 2007 19:03 GMT

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

Reply to this Message

Douglas J. Steele - 31 May 2007 19:17 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Is there a way to have a combo box include a selection in the drop down
> that
[quoted text clipped - 9 lines]
>
> Thanks

Reply to this Message

Ofer Cohen - 31 May 2007 19:56 GMT

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

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

Signature

Good Luck
BS"D

> 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
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message