Your suggested query will produce all records where the CustID is NULL. He wants to filter out those CustID from the query. At least that's how I understand it, maybe he can clarify.

The question I would have is how those customer ID's got to be NULL in the first place.

>Well, His request is clear "How to filter out those CustID having blank data in the SELECT statement?"
>he said "having blank".
>
>Correct.
>
>
>>I think you meant IS NOT NULL.
>>
>>>"SELECT * FROM Customer WHERE CustID IS NULL ORDER BY CustID"
>>>
>>>
>>>
>>>>How to filter out those CustID having blank data in the SELECT statement?
>>>>
>>>> .Open "SELECT * FROM Customer ORDER BY CustID.....
>>>>
>>>>>Hi,
>>>>>Try to include the sort in your SELECT statment like this :
>>>>>
>>>>>.Open "SELECT * FROM Customer ORDER BY CustID",cnn1,adOpenKeyset,adLockOptimistic
>>>>>
>>>>>Hope this help
>>>>>Rgrds
>>>>>
>>>>>
>>>>>>I tried to sort the Recordset but it doesn't display correctly.
>>>>>>Anything when wrong with my codes as follows:
>>>>>>
>>>>>>Set rsCustLookup = New ADODB.Recordset
>>>>>>With rsCustLookup
>>>>>> .CursorLocation = adUseClient
>>>>>> .Open "SELECT * FROM Customer",cnn1,adOpenKeyset,adLockOptimistic
>>>>>> .Sort = CustID
>>>>>> .Requery
>>>>>>End With
>>>>>>
>>>>>>Set dcCustIDList.RowSource = rsCustLookup
>>>>>>dcCustIDList.ListField = "CustID"
>>>>>>dcCustIDList.Refresh