I have a form to allow users to select historical data from a table by any of several criteria using combo boxes. The grid loads fine at Form load, but when the selections are made, and I try to load it again with the recordset from the selection statement, I get the following error:
Run-time error '30023':
Unable to access data. DataSource settings may be incorrect, or the DataSource functionality may be limited.
I have tried declaring this recordset locally, and in the General section. I am clearing the grid, before opening the recordset and before setting the DataSource value to the recordset. I have verified that, when I reach the statement assigning the DataSource for the grid, that my sql SELECT statement is correct, that my recordset is open, and has the selected data.