Hi Guys,

I have a form with a list box. The multi column list box in the form gets populated with data from a text file.

Now I want to filter data in the list box by controls on the form. For instance i would like to see all records in the list box where date cell value of listbox record is today. Or for example display all records in listbox where customer cell value of listbox record = John Smith

The way I am filtering now is setting date in code itself but thats a pain in the neck because if i want to see records for different dates i have to go back and modify code and set the date there. Id rather user a control on the form itself to filter data in list box. much easier that way. The question is can that be done. if yes what syntax should i be using


any help/suggestions would be appreciated.

Regards,