I want the macro to open a report name "rental1" when [Forms]![Receipts]![returndate]>[DateDue]....
And open report name "rental2" when [Forms]![Receipts]![returndate]<=[DateDue]....

How do i do it? My current project open two reports, one the desired one, the other the error one?

Plz help.... Attachment is up

Thanks

I tried running the macro but it crashes (missing a report or something)

1 thing tho, as a general rule, dont do these things using a macro. Its messy and unreadable. Try doing it in VBA instead.

Regards

Well... If thats the case, thank you..

i am not gd in VBA

It is therefore an ideal opportunity for you to start learning. Once you get to grips with it, you will never (well, never say never;)) go back to using macros.