How to create a custom report from the a form

[Mantaii]

Hi!
I have a feeling this may be the first of many questions when building my new database but I hope you are able to help me.

I am building a database to allow me to create monthly reports on finishing positions for a road running championship race.

So far I have managed to create a report which uses queries and data that is input but now I have a problem.

My report shows me all the data for all of the months but what I would like to do is have a form with a drop down list which allows me to select a month.



Once I have selected the month I would click on a command button which then shows me a report of all the runners, their finishing positions and times for that specific month.

Is this possible and are their tutorials online which I can follow to do this first step.

Thanks

[pbaldy]

This would be one way:

http://www.baldyweb.com/wherecondition.htm

using OpenReport instead of OpenForm.

[Mantaii]

Hi!
Thanks for that, I have got the button working but it seems to print rather than just open a report - it does print the correct report though so that's a start!

Will look in to this but thanks again for the help!

edit: fixed it,

DoCmd.OpenReport "official_finish_time", acViewPreview, , "Month_Year = " & Me.cboMonth

Just added the ,acViewPreview, and this seems to prevent it printing but just allows you to preview the report! Perfect. Now to move on to the next part of the project

O.

[pbaldy]

Glad you got it sorted out.