"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