hi all.
this might sound a bit basic, but so are my skills at the moment with access.
the thing im looking to be able to do is...

How do i make it so a report opens when i click a button in a form... is it possible? im sure there must be a way.
cheers all

ViTA

Good morning.
Once you have created your button, create an "on click" procedure. (I don't recommend using the wizard for this...my opinion is that it is easier to create a button with out the wizard when you are going to create your own event for it.)
For the code, you'll use the following line of code:
Docmd.OpenReport "Report Name", view preferred, filter, condition, window mode, open arguments

The "Docmd.OpenReport" you will type in. The view, filter, condition, window mode, & opening arguments are all items that you chose depending on exactly how you want the report to open.
I hope this helps.

Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

Really? I'm just the exact opposite. When I create a button with an event I let the Wizard do its thing and then I tweak the code it generates with what I want. It's great because it does 80% of the typing I would have done without syntax error or misspelling; and it takes care of "Now what exactly is the syntax for that command?" or "Now what command was that again?"

Vita, if you do elect to keep the Wizard on, you'll see the command Laura talked about and all you have to do is tweak it.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

zzzzzoooommmmm
straight up and over my head.

i understade the whole = Docmd.OpenReport "report name" bit and where to put it (the onclick field) but what i dont get if the filter, condition, window mode..... and is the expression builder the wizard that you are tlaking about??

sorry for my ignorance but i am trying to learn this, and not haveing a teacher or a book that goes past the basics is a bit hard :>

thanks all
VitA

Don't panic!

In design view on your form, use the toolbox create a new button, choose to create an open report button, let the Wizard create the button then edit the code it creates. You'll see a line that starts with "DoCmd.OpenReport". Place your cursor on the word "OpenReport" and press the F1 key. You'll get help on everything Laura talked about.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division