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!

 

[Joe4]

Cross-posted: OpenReport macro question

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #10 here: Forum Rules).

This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

For a more complete explanation on cross-posting, see here: Excelguru Help Site - A message to forum cross posters).