path name and wild card

[rcollins]

Here is the criteria I am using for my report...

(Permissions.Path)=[Forms]![frmCriteria]![Combo4])

On the criteria form, if I pick R:\Acct\ from the list, I get just those values. I would like to get more, like R:\Acctg\EXCEL\ ACCOUNTS PAYABLE, but am not sure how to use the wild card here. So far all of my attempts have been not good. Please help

[NeoPa]

Usually the following should work :

(Permissions.Path) Like [Forms]![frmCriteria]![Combo4]) & '*'

[rcollins]

Worked great not sure what I was missing

[NeoPa]

Your code was basically saying "Find only those items which match the string exactly".
My version says "Find all items that start with the string".