Filtering Text Boxes 1

[infinitx]

Hi,

I want to filter a text box not to display the word "none" if there is such record present. I also want to filter out Null Records.

In combo box, I do it this way:

SELECT [ICL 1].[ICL 1], [ICL 1].ItemID2 FROM [ICL 1] WHERE [ICL 1] Is Not Null And [ICL 1]<>"None";

How do you do it with a text box?

Thanks a lot!

----
Alex

Anytime things appear to be going better, you have overlooked something.

 

[PHV]

Something like this ?
=DLookUp("ItemID2", "[ICL 1]", "[ICL 1] Is Not Null And [ICL 1]<>'None'")

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

 

[infinitx]

Thanks PHV!


----
Alex

Anytime things appear to be going better, you have overlooked something.