Customized Dialog Box (1 Viewer)

Melody

Registered User.
Local time
Today, 05:24
Joined
Aug 11, 2000
Messages
47
I've created an unbound form that prompts for report criteria. I know I've left something out somewhere, because when I run the report, which pulls up this dialog box, I enter the criteria I want, then I get this error:

The object doesn’t contain the Automation object ‘DateRangeForm’.
You tried to run a Visual Basic procedure to set a property or method for an object. However, the component doesn’t make the property or method available for Automation operations.
Check the component’s documentation for information on the properties and methods it makes available for Automation operations.

I created a macro group that consisted of four macros: ok button, cancel button, openform button, close form button. I then put the criteria:
Between [Forms]![DateRangeForm]![Beginning Date] And [Forms]![DateRangeForm]![Ending Date]in the underlying query of my report in the OrderDate column.

Any suggestions? Thanks!!!!!!!
 

Jack Cowley

Registered User.
Local time
Today, 05:24
Joined
Aug 7, 2000
Messages
2,639
I would suggest that you open your DateRangeForm, fill in the dates and then click a command button on the form to open/print your report.
 

Users who are viewing this thread

Top Bottom