Using forms as criteria with wildcards
Posted on 2004-08-04
I am using a form to set the criteria for a form that opens from it. the button executes the following code:
stDocName = "View_Item"
stLinkCriteria = "[Equipment]=" & "'" & Me![Equipment] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
I'd like to be able to put a wildcard character in the equipment field-- in other words, use 34* and get equipment #'s 345 and 348. right now, if i use a * or anything else i can think of it just filters out everything.
Thanks for any help.