Dropdown Box Selection to Filter Report Output

[dargo72]

I am trying to run a report based upon criteria selected from a combo box on a Form.



Specifically, I have a report called "Items Assigned To Me" which has a field called "Assigned to"

I made an unbound combo box on a form that pulls peoples names from a separate table.

I would like to click on a button next to the Drop Down and have the report show only records related to the name selected in the dropdown.

I do not know how to do this. Also, do I need a query as an intermediary?

Thank you,

[pbaldy]

You can use this method:

BaldyWeb wherecondition

[dargo72]

You can use this method:

BaldyWeb wherecondition

Thank you. The button does open the report (in preview mode) but populates all fields with "Name#"

Here is the code I used with the button.

Private Sub Command23_Click()
DoCmd.OpenReport "Items Assigned To Me Report", acViewPreview, "Assigned to = '" & Me.SelectionBox & "'"
End Sub

Any Thoughts? Do I have to do anything on the report end of things?

Thank you,

[pbaldy]

I think you have it in the wrong position. You also need to bracket the field name with the inadvisable space. Try

DoCmd.OpenReport "Items Assigned To Me Report", acViewPreview,, "[Assigned to] = '" & Me.SelectionBox & "'"

[dargo72]

I think you have it in the wrong position. You also need to bracket the field name with the inadvisable space. Try

DoCmd.OpenReport "Items Assigned To Me Report", acViewPreview,, "[Assigned to] = '" & Me.SelectionBox & "'"

Still the same result, report runs but shows "Nam#"" in all fields. Do I need to put anything for the datasource for the report?

[dargo72]

Still the same result, report runs but shows "Nam#"" in all fields. Do I need to put anything for the datasource for the report?

Got it! I had to use the original query as the datasource, but allow filters.

Thank you!

[pbaldy]

Sorry, I thought you already had the report working. Glad you got it sorted out.