After you change the .RecordSource of the Adodc, you may need to do an Adodc.Refresh. Trying adding that and see if it helps.