help please: making reports/queries by typing in field data?

[tinyelvis]

Please forgive m=y lack of knowing how to even phrase this - I have not worked with Access in 10 years, and I have fogotten quite a bit.



I am creating a registration DB for a school. My tables are all set up and working, but what I cannot figure out how to do is to create a report such that upon opening it, a little dialogue box pops up and asks me "Term" and "Class" and then I type those things in and viola I get a class list.

Thank you so much for any help - I know this is something simple, but my brain let go of this a long time ago...

[dblife]

base the report on a select query rather than a table and in the criteria section write,
=[Term]
and in the other column for class,
=[Class]

[tinyelvis]

thanks dblife - I assume you mean to enter those into the query criteria, but when I did that, it did not work.

Am I doing something wrong?

Thanks!

[dblife]

it's a function i use in a2003 - might be it doesnt work in a2010... cannot comment on this as i do not use a2010.

[HMEpartsmanager]

I have a report where I printout tools purchased for the year. I created a query for it of the data I wanted; qryToolsPurchased. As one of the fields, I have [Employee ID#: ?] under the Employee ID # field.

Then in my report, I use the qryToolsPurchased query and when it runs, it asks me what Employee, I answer, and it kicks me out the report.

I have other reports similar where I have created the query of the data I need, and in the field instead of enterying TF100, I would have [Employee ID#: ?]; or in a boat field, have it ask me for the boat, etc...

Then I will only have the 1 query, and the 1 report, to get the information I want. Whether it is 30 employees and getting tool purchases for the year, 1 report; or if I want a list of all parts used on boat 30, I get that 1 report.

Something like that may work; a Query setup with the question being asked within the query so when the report runs, it will ask the question.

Tim

[tinyelvis]

Tim, AWESOME!!! Thank you so much. I knew it was simple! That worked. Can you have the little dialogue box give an example of what to type - for example, it would say "Term: ? (fall, spring, etc.)"

THank you so much for your help!!

[HMEpartsmanager]

Tim, AWESOME!!! Thank you so much. I knew it was simple! That worked. Can you have the little dialogue box give an example of what to type - for example, it would say "Term: ? (fall, spring, etc.)"

THank you so much for your help!!

I believe so. I am not sure, but I think the way you have it [In Brackets], is what will display for the question. Give it a try, experiment.

So change your field criteria to [Term: ? (Fall, Winter, Spring, Summer)] and it should work.

Tim