How to fix error: Run-time 2001 You canceled the previous operation.

[Heather M]

I am receiving a Run-time 2001 You canceled the previous operation.

I have a form which has unbound boxes where you select the date and set a role. The query runs for one role for every month. When the second role is set, the query runs for every month except October. I have checked the data and have even re-entered it.

When I press Debug, it has highlighted DoCmd.OpenQuery Me.cboReport.

If IsNull(Me.cboReport) Then
        MsgBox "Please select a report."
    Else
        DoCmd.OpenQuery Me.cboReport

I cannot understand why it works for October data using the SO Role but will not work for October using the Technical Content Role.

All data is entered on a sharepoint table which utilizes Drop down menus.

Does anyone know where I should look?

Thank you,
Heather

[colintis]

Are you saying you are putting Me.cboReport as a parameter to filter the result?

The Docmd.OpenQuery doesn't take any criteria(s) for the query's WHERE clause. Therefore what you are doing is suppose to create a number of queries as the amount of choices that you have in the combobox.

Can you also post the query that runs as well?