Have you seen this error before

[accessdork]

I keep getting this message everytime a try to invoke a Preview button I have designed to preview reports based on entered form criteria.
"A problem occurred while Microsoft Access was communication with the OLE server or ActiveX control."

Has anyone seen this? What do I do? My button is not doing what it is supposed to (namely, run a report based on the entered criteria). Please help.

 

[AlanS]

Just a wild guess, but this may be due to either (1) a broken reference - with any code module open, check Tools, References for problems; or (2) the ActiveX control may not be properly registered.

 

[accessdork]

Could you then tell me how to design a report when invoked,
1. Opens a form (let's call it form1) asking for a beginning date and end date.
2. When you hit an "OK" button on the form the report is generated.

I already have a query that the Report relies on as it's control source. In the query I tell it to look for the Two fields (beginning and end date) on form1.

 

[Jack Cowley]

I would open a form first (not from the report) with the beginning and ending date fields and then have a button on the form that opens the report....

 

[accessdork]

Thanks for your help Jack! It worked out well!