Can you test the recordsets?
The only way I am able to reproduce this is if I turn of the MySQL server so that the recordsets do not work.
double click the MySQLi recordset and click the test button to make sure they work before trying to use the Dynamic List button.