Using Like on Reports Form

[Bev M. via AccessMonster.com]

I have a report form with fromdate, todate, and admin as parameters. Admin
is a drop-down list of admins. I have several reports on this form. When I
click on a report, I'd like to filter the report based on the above
parameters chosen. I'm using the following in my report query:

Like Forms![frmReport]![Admin] & "*"

But this returns similar records that I don't need. Like: Maden, Madison,
etc. Is there a way around this and have it bring up only the records that
I chose from my Admin drop-down list???

Thanks,
Bev

 

[Van T. Dinh]

Have you tried setting the criteria to just:

Forms![frmReport]![Admin]