OpenReport macro question

[chdui]

Hi all,



First time using Access 2013 here.

I've built an Access Database that captures information about employee ticket quality using one form and drops it into a table (QA Reviews). What I would like to do then is run a report to pull the last 5 entries for a specific employee.

What I have done is create a Report that has all of the fields I need (QA Review Report) and then have created a second form (Run QA Report) that includes the 'Consultant Name' field and an OK button that will run a macro when pressed.

What I have so far in the macro code is as follows:
DoCmd.OpenReport "QA Review Report", acViewReport, "", """Consultant Name="" & [QA Reviews].[Consultant Name]", acNormal

However, when running this form, it still doesn't produce anything and I also have not figured out how to get it pull the last five entries in the table for that specific 'Consultant Name'.

Any assistance would be greatly appreciated.

Thanks!

[June7]

That is not macro code - it is VBA.

Too many quote marks. Variables do not go within quote marks. Parameters for text fields need apostrophe delimiters. Field name has space so need [] delimiters. Probably don't need the [QA Reviews] prefix.

DoCmd.OpenReport "QA Review Report", acViewReport, , "[Consultant Name]='" & Me.[Consultant Name] & "'", acNormal

Try setting the report RecordSource query with TOP 5 parameter.

[chdui]

Thanks for your reply! Sorry, meant to say that I converted the Macro to VBA in order to view the code better.

So running into an additional problem...however, the code does work to an extent.

When I run the form and choose the Consultant's name from the drop down list, the report will open and display the results. What happens, though, is that no matter the name I choose from the drop down menu, the report will just display the selected name (from the 'Run QA Report' form) in the 'Consultant's Name' box. In essence, it is changing the name from my master table that holds all of the information to whatever name I choose when I ask it to run the report. This new name then gets saved in the 'QA Reviews' master table.

To try and get around this error, I created a query ('QAQuery') that asks for the Consultant's name with [Which consultant?] in the criteria box. While the box pops up prompting for the consultant's name, it again, will take any name and just change the output name to whatever I entered into the query parameter box. I'll note that if I enter a non-existent name in my database, it will produce no results, as it should.

I feel like I have explained that terribly, but if you're able to offer any assistance, guidance would be appreciated.

[June7]

Controls used to input filter criteria must be UNBOUND.