It is natural to assume that the data for a Data Control will re-load and populate your controls when you change the RecordSource, however this is not the case.
In addition to setting the RecordSource you also need to tell the Data Control to reload the data, and you may need to tell your controls to update themselves to show the new data too.
This is how you can tell the Data Control to reload data like this:
VB Code:
'(change ADODC1 to the name of your data control)
ADODC1.RecordSource = "..(your recordsource text here).."
ADODC1.Recordset.Requery
ADODC1.Refresh
If you are showing the data in controls (textbox/grid/etc) that do not update after using the above code, you will need to refresh them too, like this:
Reply With Quote