Changing cbo select 1

[BabyPowder2u]

I have a form which has 2 cboSelects

1. SelDiv
2. SelectPOC

The Div is selected, then used to pull up a list of POC's. The select for the POC is:

SELECT tblPOC.POCID, tblPOC![FirstName] & " " & tblPOC![LastName] AS POC1
FROM tblPOC
WHERE ((([tblPOC]![DivID])=[forms]![frmPOC_ModDel].[SelectDiv]));


I would like to modify this so if no "Div" is selected, all POC's in the table will be pulled into the list.

Any help to accomplish this would be appreciated.

T

 

[PHV]

SELECT POCID, FirstName & ' ' & LastName AS POC1
FROM tblPOC
WHERE DivID=[Forms]![frmPOC_ModDel]![SelectDiv]
OR [Forms]![frmPOC_ModDel]![SelectDiv] Is Null

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886