User Generated Reports?

[Kiernan]

I'm working on an inventory database. I have a field called Item which pulls its information from a lookup table which has 84 different item types.

What I'd like to do is be able to print a report for each type of item on demand from the user without doing a query and report for each. I'd like for the user to be able to say that they want an inventory of Item "B" and have it generate itself.

I'm sure this is possible, but I have no clue how to do it. Any help would be grealy appreciated.

 

[Chesterex1]

What you can do is create a generic query eg. qryByItem .
In the Item field of the query use the value of the field on the form . (eg text0)
The Item field criteria in the query would then be:
Like Forms![frmThisForm]![Text0]
You can then make a generic report based on this query.
Then have a command button on the form that will print this report.
The query and it's report will only generate when the control on the form has information.
Hope this was helpful
Thanks
Tim

 

[Kiernan]

I'll give that a shot. Thanks!

 

[Kiernan]

"In the Item field of the query use the value of the field on the form . (eg text0"

This is the only part I'm not understanding. What exactly is the value of the field?

 

[Chesterex1]

I am understanding that you have a form bound to a query or a table. The "Item" field in the form(whether a textbox or a combo box) would be the basis for your generic query.
Thanks
Tim

 

[Kiernan]

Ok, my query and my report are working fine. When I execute them, it asks for a parameter. I just type in one that matches the specific Item I want, and it runs. I hope that was the effect you were trying to get me to accomplish, because that's what I have.

However, from my form, when I create a command button to execute the report, I don't get the option to enter my parameters. It just opens a blank report.

Any ideas?

 

[Chesterex1]

That is because there is no data in your text field.
If you give me your email address - I will send you a sample database. Email me at tim.paul@sympatico.ca with your email address.