Querytable refresh from form

Hi All

I have a querytable that's linked to a table in an access database, I'm using ADO to delete a record from the table from an Excel form - problem is when I use VBA to refresh the querytable the record remains.

I can manually right click the querytable and refresh and the record will be removed, any idea's where I'm going wrong

Please Login or Register  to view this content.

Thanks!