Error Message when Cancelling Input

[specsol]

I am creating a form that displays a chart. The Form is created via the Chart Wizard which uses a query to construct the data to be charted. The query requests 2 parameters from the user. If the user hits the cancel button on the parameter request form, an error message comes up. "An error occurredwhile sending data to the OLE server (the application used to create the object". None of the suggested causes are relevant. Running the query on its own and cancelling in the same way does not generate any message. If the input data is entered without cancellation, the chart works fine. Is there any way to suppress this message? Any help will be much appreciated! The database is constructed with Access 2002.

 

[HiTechCoach]

I have found the pop up parameters in a query are not very user friendly. Since you can not have any good error handling or any data validation, I avoid them.

I have found that it is much petter to use a form to collect the values to be used as criteria in a query. This way a used can cancel then process and ytou can handle this as needed without the unwanted error messages

 

[specsol]

Thank you for this. I rather feared that might be at the root of the problem. I obviously need to learn something more about Access

 

[DCrake]

Here is a document regarding passing variable from and to forms and queries that are not form dependant.

This might help you, if not now but in the future.

David

 

[specsol]

Thank you for that. It looks as if it helps. I will need to look and see how many places in the rather complex database where it needs to be applied!