Creating Report with Criteria selected from Form

[sis19signe]

I am creating an inventory database for the company I am co-oping with. This is my first time working in Access. I want to know how to create a form that selects the criteria in a report. I don't know any VB or SQL. If you can help, that would be wonderful. Thank you.

 

[SgtJarrow]

Without more information from you as to what it is you are really trying to do, take a look at help file for:

DoCmd.OpenReport

And some of the optional arguements you can use. Most importantly for you is the WHERE portion...which allows you to filter a standard report based on selections from combo/list/text boxes or whatever.

****************************
Only two things are infinite, the universe and human stupidity,
and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III
MCSA, CNA, MCP, Network+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[ConnellG]

The technique you need is called QBF (Query by Form). You create an unbound form with unbound text boxes for the user to type or select (from combo box) whatever is to be the criteria for the report. The report is based on a query that includes the criteria from the report. The query might have a criteria such as:
Forms![Unbound Form Name]![Unbound Field Name]. If the form includes fields that the user may leave blank in order to obtain all the data, use the following version of the above query criteria:
Forms![Unbound Form Name]![Unbound Field Name] OR Forms![Unbound Form Name]![Unbound Field Name]Is Null