Help needed - newbie having users select the criteria for a report

[StevenB]

Howdy folks, yet another Access newbie here.

I'm trying to create a fairly simple report for a hockey database I've created. The report is essentially a "box score", where all of the data required is pulled from one table.

The problem is this:

Currently, the report creates a box score for every game we've ever played. I'd like to have a form appear when I run the report to ask the user which game they want to see the box score for, but I haven't had any luck.

I actually have a separate form that asks that very thing successfully - when I key in data for games, it asks you first which game you want to key data for.

I guess the bottom line is I'm not sure how to bring that piece of form into my report, how to then "activate" it so that it runs when you open the report, and finally, I don't know how to tie it to the report so that the selected record is used for the report criteria.

I've tried working through the samples provided by Microsoft, but it hasn't helped.

Any suggestions would be greatly appreciated. In fact, at this stage I'd even like an overview, something like this:

You want to create a sub-form in your report, have it start in an event, etc. etc.

 

[Rohdem]

I think you need to create a query that the report is based on. The query should include all the fields from the table. In the criteria section for the game number or whatever field you want the user to enter the data for, place a prompt inside of brackets, i.e.

[Enter the game number]

When access runs a query and comes across a field in the criteria section that it doesn't recognize, it will prompt the user for the data that it is to use. So when access looks for a field called [Enter the game number], it won't find it and it will ask the user to enter it. It will appear to the user as if they are being promted for a response.

I hope that made sense to you!!!

Good Luck!

Mike Rohde
rohdem@marshallengines.com