i have created a report that has the site numbers for the jobs i set up a micro on the site number field to open the form that has all of the information of that site. I get the error message The object doesn't contain the automation object'form' i am not sure how to correct it. Can any one help?

To start with, opening a form from a report is kind of backward. :)

Are you by chance using Access 2007? And as Ken said, normally one would open a report from a form, not a form from a report.

But, I'm guessing you are using 2007 which has events like a click event for a control/section in reports now. The error you are seeing is most likely because you have put something somewhere where it is not supposed to be, or have used the wrong syntax.

Can you provide a few screenshots of your macro in design view so we can see the action and arguments (open the builder, or Zoom box, if necessary to show the entire argument).

The only way I have managed this is On Close Event Open one Form as I have a Report Selection Form and users can go back and request another Report.

Simon