Access Calendar Style Report ...

[angelandgreg]

I have a great form that is used to schedule volunteers by clicking on New or editing an existing volunteer by clicking on the name on the date on the calendar form.

Once completed, I need to print it out as a report.

I have gotten some help by others examples (the form and all) but am stuck on a Compile Error and unable to figure out what the cause of this is. The field exists on the form (control) so why is it erroring out? How can I fix this so the Report will finally display the calendar with the scheduled information just as seen on my calendar form?

NOTE: the same form displays various information based on which information I select from an "options" form.

Hope that made sense? I don't know how to upload the zipped database so someone can see the database.

 

[angelandgreg]

Duane,
thanks for trying to help.
I finally got what I needed although I don't know why I didn't think of it before. The simplest solution was right there in front of me (although not the exact one I was trying to do but all-in-all, the end result is the same).

I have this problem of making things more difficult then it really needs to be. %-)

Anyway, after looking at this thing from all this different angles, I realized that I could get what I needed but simplye creating a simpler form for just the results then doing the report from that. Avoided all the ActiveX Controls (which is what I was having issues with).