Vba to retrieve Access recordset no longer works after additional columns added

Hi all
I have been using this code to retrieve and filter a recordset from Access. At present I have moved over to a test file while I add features to improve reporting.
This code was not what I was working on and I only noticed it after a few days so cannot pinpoint what the change was.

The Table 'Pending' has had 5 extra columns added but all at the end so no format change
The Field 'Delivered' has a simple X to denote delivered so this listbox views pending orders
I increased the number of columns in the listbox but now find that no records are retrieved but if I aim back at original Access database all works fine

Please Login or Register  to view this content.

I cant think why the records can no longer be retrieved as they do exist
Any ideas??

Changed text in red and all now seems good

interesting information