Command Button to Open Form and Filter using Wildcard
Posted on 2013-12-11
We have Office 2010. In Access 2010 I have a form named "frmDocket". On this form I have a Text Box named "txtInitials". I also have a Command Button which opens the form "frmDktAtty". On the form "frmDktAtty" I have a field named "RoutedTo".
When you click the Command Button on the form "frmDocket" it currently filters with the logic (txtInitials = RoutedTo).
Here is my code:
DoCmd.OpenForm "frmDktAtty", acNormal, "", _
"[RoutedTo]LIKE " & "'" & "*" & Me![txtInitials] & "*" & "'", , acNormal
What I really need is the following logic, but I cannot figure out how to alter my code (above) without getting an error. I've tried so many variations so please don't ask me what I've already tried.
txtInitials = (Like "* [RoutedTo]*")
Can anyone assist me with this.
Thanks in advance!