Generating Report Based off input from a form

[bryanCalabro]

I have three tables that keep track of the projects going on for my local municipality. The tables are project, orders, and change orders. I am in the midst of creating a user interface based solely off of forms and navigation buttons. On one of those forms I want the user to be able to input the projectId and it print a report of all of the orders that correspond with this projectId. I am taking the input from the form and running through a VBA Statement like this... DoCmd.RunSQL ("SELECT * FROM Project WHERE Project.projectID = " & me.inputId), which is giving me the information I want, but now I just need to put that into a report. Any suggestions?

[RuralGuy]

DoCmd.OpenReport supports a "Where Condition" argument.

[bryanCalabro]

Thanks RuralGuy, i have been playing around with that. However I am trying to make the report based off of the form input. For example, if the user inputs into three text fields, projectID, start date, and end date, then i want to generate a report with all of the orders for that project id within the given time slot. In the where condition im trying
"Order.projectId = " & me.inputId & " AND Order.startDate > " & me.startDate & " AND Order.endDate < " me.endDate

[June7]

Parameters for text fields need apostrophe delimiters, date fields need # delimiters, number type do not need delimiters. Probably don't need the Order. prefix. Missing an & for concatenation.

"projectId = " & me.inputId & " AND startDate > #" & me.startDate & "# AND endDate < #" & me.endDate & "#"

If you want the date range to be inclusive, use >= and <= operators.

This requires input into all 3 textboxes.

[bryanCalabro]

I'm trying it and it's still not working, I am now trying with just "projectId = " & me.inputId but its printing out the entire report with all records. Here is the exact code DoCmd.OpenReport "OrderReport", acViewReport, "[projectId] = " & Me.id

[June7]

If you want to provide db for analysis, follow instructions at bottom of my post.

Should that code be Me.id or Me.inputId? Are these UNBOUND textboxes for input of filter parameters? What is name of textbox?

[bryanCalabro]

This is my DB. I'm making it for old people who want a user interface inside the program, which is what the navigation form is for. And i double checked all of the names, they line up, and the text field is unbound.

[June7]

The criteria is in the wrong argument. Missing a comma.

DoCmd.OpenReport "OrderReport", acViewReport, , "[townshipProjectId] = " & Me.id

[bryanCalabro]

Thank you June7! That did the trick. This is my first time using access so do you have any other pointers for me based off what you saw?

[June7]

Might want to remove spaces from object names.