Hi,

I have a listbox on a form that pulls data from several sheets. The list box pulls from a spreadsheet range called History. Right now it pulls all rows of the same item but has different dates and status of the item. I want it to only pull the distinct item number and lot number from the range. I thought I could do this with sql statement but since the actual table is an Excel range in the same workbook I don't necessarily know how to call the data source.

Right now the property of the listbox is set to rowsource = History

I basically want to filter that by using 
Select Distinct(History.Kit), History.Lot from History
Any help would be appreciated.

Gvsandrs