Hi. I currently use the long\short mod and I'd like to exclude records from coming up in searches based on the data in one column.

I had a database that can't have any more fields added to it as it's imported from another program daily.

Now let's say I have two columns that come into play here. I have 800+ records and column A for each one is either apples, oranges or pears.

I would like to display a list of data for column B but only for apples and oranges, and not pears.

Any ideas?

Thanks

A simply code and I was able to do this myself. Thanks for reading.