I have a parameter query based on DAFItem in a form and want the query to return all DAFItems with that base, so I tried adding a wildcard to the end of the string (see below) but it does not not work.
If I take the & "*" off the end the query returns only the exact matched DAFItem.
If I replace this string with a DAFItem* in the criteria of the query it works. (Such as 1234567*) It will return 1234567DAF, 1234567PE, 1234567PET, 1234567ABC, etc.
Here is the string I am working with now:
[Forms]![F_DAFPNReview]![F_PartReviewMaster].[Form]![DAFItem] & "*"
How can I pass this string to the query and a wildcard as well?