I have a form tied to a record set. On this form I also have 2 unbounded combo boxes (Archive and id). The combo boxes are used to filter out on the 2 fields present in the recordset/form. The combo boxes are populated with acceptable values from the base table.

When an archive combo box value is selected, the form recordset is updated accordingly. I use me.recordsource to reset the form records. In addition, the ID combo box is updated with acceptable values for a given archive value. All this is done in the AfterUpdate event for the archive combo box. This works fine.

The next step is to select the combo box ID value. This is where my problems occurs. Once a value is selected, I take the archive combo box value and the ID combo box value and reset the form recordsource again.

However, Access chokes on the me.recordsource statement with the error 'You canceled the previous operation'. I can't figure out how to fix it. Any ideas?