Hi All

I have a listbox which has all the dates. The Access database has the following fields:

Date, Batch Number
01/06/2014 10004
01/06/2014 21782
01/06/2014 10008
01/06/2014 65555
04/06/2014 19900
04/06/2014 19911
04/06/2014 65555

Now when the user clicks on any of the item in the listbox and press Enter button then it should display First Batch Number and Last Batch Number of the selected item of Listbox.

I want to write the VBA code in Excel that will check from the Access database based upon the listbox date selected.

Thanks